Fifa Players Dataset

Unlocking Insights: Analyzing FIFA Players' Dataset through Web Scraping

@kaggle.pushpakhinglaspure_fifia_players_dataset

Table List

1 table(798.71 KB)

Fifa

@kaggle.pushpakhinglaspure_fifia_players_dataset.fifa

798.71 KB
19656 rows
14 columns

unnamed_0 Unnamed: 0	name Name	country Country	position Position	age Age	overall_rating Overall Rating	potential Potential	duration Duration	team Team	value_m Value € M	wage_k Wage € K	total_stats Total Stats	photo_link Photo Link	country_flag_img_link Country Flag Img Link
	Pape Matar Sarr	Senegal	CM	19	71	81	2021 ~ 2026	Tottenham Hotspur	4	25	1865	https://cdn.sofifa.net/players/259/868/23_180.png	https://cdn.sofifa.net/flags/sn@3x.png
1	Manuel Ugarte	Uruguay	CM	21	79	85	2021 ~ 2026	Sporting CP	26	11	1950	https://cdn.sofifa.net/players/253/306/23_180.png	https://cdn.sofifa.net/flags/uy@3x.png
2	Mykhailo Mudryk	Ukraine	LW	21	75	85	2023 ~ 2031	Chelsea	12.5	57	1836	https://cdn.sofifa.net/players/246/340/23_180.png	https://cdn.sofifa.net/flags/ua@3x.png
3	Israel Reyes	Mexico	CDM	22	75	83	Free	Mexico			2087	https://cdn.sofifa.net/players/252/008/23_180.png	https://cdn.sofifa.net/flags/mx@3x.png
4	Lewis Hall	England	LB	17	61	79	2021 ~ 2025	Chelsea	0.825	2	1710	https://cdn.sofifa.net/players/266/127/23_180.png	https://cdn.sofifa.net/flags/gb-eng@3x.png
5	Julio César Enciso	Paraguay	CAM	18	65	83	2022 ~ 2026	Brighton & Hove Albion	1.8	5	1589	https://cdn.sofifa.net/players/255/434/23_180.png	https://cdn.sofifa.net/flags/py@3x.png
6	Randal Kolo Muani	France	RM	23	82	86	2022 ~ 2027	Eintracht Frankfurt	44	40	1989	https://cdn.sofifa.net/players/237/679/23_180.png	https://cdn.sofifa.net/flags/fr@3x.png
7	Arthur Vermeeren	Belgium	CM	17	70	87	2022 ~ 2026	Antwerp	3.8	500	1765	https://cdn.sofifa.net/players/269/859/23_180.png	https://cdn.sofifa.net/flags/be@3x.png
8	Andrés Iniesta Luján	Spain	CM	37	79	79	2018 ~ 2024	Vissel Kobe	5.5	10	1918	https://cdn.sofifa.net/players/000/041/22_180.png	https://cdn.sofifa.net/flags/es@3x.png
9	Georges Mikautadze	Georgia	CAM	21	71	81	2019 ~ 2026	Metz	4.2	5	1862	https://cdn.sofifa.net/players/254/551/23_180.png	https://cdn.sofifa.net/flags/ge@3x.png


CREATE TABLE fifa (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "country" VARCHAR,
  "position" VARCHAR,
  "age" BIGINT,
  "overall_rating" BIGINT,
  "potential" BIGINT,
  "duration" VARCHAR,
  "team" VARCHAR,
  "value_m" DOUBLE,
  "wage_k" DOUBLE,
  "total_stats" BIGINT,
  "photo_link" VARCHAR,
  "country_flag_img_link" VARCHAR
);