Dane ze strony www.football-data.co.uk
- Pobranie danych w formacie csv
- Zaimportowanie danych do Google Refine
- Wyczyszczenie danych oraz edycja danych za pomocą Google Refine
- Eksport danych w formacie JSON
{
"Div" : "E0",
"Date" : "2005-08-13",
"HomeTeam" : "aston_villa",
"AwayTeam" : "bolton",
"Full_time_home_goals" : 2,
"Full_time_away_goals" : 2,
"Full_time_result" : "D",
"Half_time_home_goals" : 2,
"Half_time_away_goals" : 2,
"Half_time_result" : "D",
"Referee" : "Riley",
"Home_shots" : 3,
"Away_shots" : 13,
"Home_shots_on_target" : 2,
"Away_shots_on_target" : 6,
"Home_fouls" : 14,
"Away_fouls" : 16,
"Home_corners" : 7,
"Away_corners" : 8,
"Home_yellows" : 0,
"Away_yellows" : 2,
"Home_reds" : 0,
"Away_reds" : 0
},
{
"Div" : "E0",
"Date" : "2005-08-13",
"HomeTeam" : "everton",
"AwayTeam" : "man_united",
"Full_time_home_goals" : 0,
"Full_time_away_goals" : 2,
"Full_time_result" : "A",
"Half_time_home_goals" : 0,
"Half_time_away_goals" : 1,
"Half_time_result" : "A",
"Referee" : "Poll",
"Home_shots" : 10,
"Away_shots" : 12,
"Home_shots_on_target" : 5,
"Away_shots_on_target" : 5,
"Home_fouls" : 15,
"Away_fouls" : 14,
"Home_corners" : 8,
"Away_corners" : 6,
"Home_yellows" : 3,
"Away_yellows" : 1,
"Home_reds" : 0,
"Away_reds" : 0
},[plik csv przed użyciem Google Refine] (/data/csv/league_dwisniewski.csv) Po użyciu Google Refine w formacie JSON