Data import
Budget: $2 – $30 USD
I would like to hire a freelancer to download all the Excel files from this website: https://www.football-data.co.uk/downloadm.php and save them into a normalized database. The current problem is that not all the files have the same format, so I would like the database to have these columns:
league, date, time, home_team, away_team, FT_home_goals, FT_away_goals, result, HT_home_goals, HT_away_goals, HT_result, home_shots, away_shots, home_shots_on_target, away_shots_on_target, home_fouls, away_fouls, home_corners, away_corners, home_yellow_cards, away_yellow_cards, home_red_cards, away_red_cards.
I would like the data to be stored in a PostgreSQL database.
league, date, time, home_team, away_team, FT_home_goals, FT_away_goals, result, HT_home_goals, HT_away_goals, HT_result, home_shots, away_shots, home_shots_on_target, away_shots_on_target, home_fouls, away_fouls, home_corners, away_corners, home_yellow_cards, away_yellow_cards, home_red_cards, away_red_cards.
I would like the data to be stored in a PostgreSQL database.