import pandas as pd # her zamanki gibi öncelikle kullanacağımız pandas kütüphanesini import ediyoruz.

import os # os metodunu kullanmak için önce import etmemiz lazım
os.chdir("C:/Users/E-A-S/Desktop/pandas-kaynak") # csv dosyamızın olduğu dizini dosyaların aranacağı dizinler arasına eklemek için yapıyoruz.

kupa=pd.read_csv("wcplayers.csv") # işlemlerimizi üzerinde gerçekleştireceğimiz csv dosyasını dataframe değişkenine atıyoruz. 
kupa

kupa.info() # özelliklere bakmaya yarıyor. Görüldüğü gibi Team değerleri kategorik bir yapıdadır. Aşağıdaki kod ile bunu kategori haline getireceğiz.

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 736 entries, 0 to 735
Data columns (total 9 columns):
Team                 736 non-null object
#                    736 non-null int64
Pos.                 736 non-null object
FIFA Popular Name    736 non-null object
Birth Date           736 non-null object
Shirt Name           736 non-null object
Club                 736 non-null object
Height               736 non-null int64
Weight               736 non-null int64
dtypes: int64(3), object(6)
memory usage: 51.8+ KB

kupa["Team"]=kupa["Team"].astype("category") # bir sütunun tipini kategori haline geirdik.

kupa.info() # gördüğünüz gibi bir sütunu kategori haline getirmemiz dosya boyutunda değişikliğe neden oldu. Hazıfa kullanımını azalttık.

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 736 entries, 0 to 735
Data columns (total 9 columns):
Team                 736 non-null category
#                    736 non-null int64
Pos.                 736 non-null object
FIFA Popular Name    736 non-null object
Birth Date           736 non-null object
Shirt Name           736 non-null object
Club                 736 non-null object
Height               736 non-null int64
Weight               736 non-null int64
dtypes: category(1), int64(3), object(5)
memory usage: 48.3+ KB

kupa["Team"].nunique() # unique sayesinde kaç farklı takım olduğunu görebiliyoruz.

32

kupa["FIFA Popular Name"] # bir sütun çekme işlemi

0           TAGLIAFICO Nicolas
1               PAVON Cristian
2               LANZINI Manuel
3               SALVIO Eduardo
4                 MESSI Lionel
5             ANSALDI Cristian
6                 BIGLIA Lucas
7                  BANEGA Ever
8            MASCHERANO Javier
9                 DYBALA Paulo
10               AGUERO Sergio
11             HIGUAIN Gonzalo
12              DI MARIA Angel
13            LO CELSO Giovani
14            MEZA Maximiliano
15                ACUNA Marcos
16          CABALLERO Wilfredo
17             MERCADO Gabriel
18            OTAMENDI Nicolas
19                 ROJO Marcos
20              FAZIO Federico
21               ARMANI Franco
22               GUZMAN Nahuel
23                 BEHICH Aziz
24                KRUSE Robbie
25               RISDON Joshua
26              MEREDITH James
27                  MOOY Aaron
28              MacLAREN Jamie
29          PETRATOS Dimitrios
                ...           
706               KHAZRI Wahbi
707                BEDOUI Rami
708    BEN YOUSSEF Fakhreddine
709              SASSI Ferjani
710           MATHLOUTHI Aymen
711        BEN MUSTAPHA Farouk
712           BEN YOUSSEF Syam
713             NANDEZ Nahitan
714             TORREIRA Lucas
715     DE ARRASCAETA Giorgian
716               LAXALT Diego
717     URRETAVISCAYA Jonathan
718           VARELA Guillermo
719                GODIN Diego
720          BENTANCUR Rodrigo
721        PEREIRA Maximiliano
722           MUSLERA Fernando
723             SANCHEZ Carlos
724               SILVA Gaston
725             CACERES Martin
726               GIMENEZ Jose
727           STUANI Cristhian
728             CAVANI Edinson
729         RODRIGUEZ Cristian
730             CAMPANA Martin
731              VECINO Matias
732               SILVA Martin
733                SUAREZ Luis
734          GOMEZ Maximiliano
735           COATES Sebastian
Name: FIFA Popular Name, Length: 736, dtype: object

kupa["FIFA Popular Name"].lower() # böyle bir hata vermesinin nedeni object yapısında olmasındandır. Çözüm aşağıdaki gibi sty.lower() şeklinde kullanmaktıd..

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-12-f420109c3830> in <module>
----> 1 kupa["FIFA Popular Name"].lower()

~\Anaconda3\lib\site-packages\pandas\core\generic.py in __getattr__(self, name)
   4374             if self._info_axis._can_hold_identifiers_and_holds_name(name):
   4375                 return self[name]
-> 4376             return object.__getattribute__(self, name)
   4377 
   4378     def __setattr__(self, name, value):

AttributeError: 'Series' object has no attribute 'lower'

kupa["FIFA Popular Name"].str.lower() # bu sütundaki bütün harfleri küçülttük.

0           tagliafico nicolas
1               pavon cristian
2               lanzini manuel
3               salvio eduardo
4                 messi lionel
5             ansaldi cristian
6                 biglia lucas
7                  banega ever
8            mascherano javier
9                 dybala paulo
10               aguero sergio
11             higuain gonzalo
12              di maria angel
13            lo celso giovani
14            meza maximiliano
15                acuna marcos
16          caballero wilfredo
17             mercado gabriel
18            otamendi nicolas
19                 rojo marcos
20              fazio federico
21               armani franco
22               guzman nahuel
23                 behich aziz
24                kruse robbie
25               risdon joshua
26              meredith james
27                  mooy aaron
28              maclaren jamie
29          petratos dimitrios
                ...           
706               khazri wahbi
707                bedoui rami
708    ben youssef fakhreddine
709              sassi ferjani
710           mathlouthi aymen
711        ben mustapha farouk
712           ben youssef syam
713             nandez nahitan
714             torreira lucas
715     de arrascaeta giorgian
716               laxalt diego
717     urretaviscaya jonathan
718           varela guillermo
719                godin diego
720          bentancur rodrigo
721        pereira maximiliano
722           muslera fernando
723             sanchez carlos
724               silva gaston
725             caceres martin
726               gimenez jose
727           stuani cristhian
728             cavani edinson
729         rodriguez cristian
730             campana martin
731              vecino matias
732               silva martin
733                suarez luis
734          gomez maximiliano
735           coates sebastian
Name: FIFA Popular Name, Length: 736, dtype: object

kupa["FIFA Popular Name"].str.upper() # sütundaki bütün harfleri büyütme işlemi

0           TAGLIAFICO NICOLAS
1               PAVON CRISTIAN
2               LANZINI MANUEL
3               SALVIO EDUARDO
4                 MESSI LIONEL
5             ANSALDI CRISTIAN
6                 BIGLIA LUCAS
7                  BANEGA EVER
8            MASCHERANO JAVIER
9                 DYBALA PAULO
10               AGUERO SERGIO
11             HIGUAIN GONZALO
12              DI MARIA ANGEL
13            LO CELSO GIOVANI
14            MEZA MAXIMILIANO
15                ACUNA MARCOS
16          CABALLERO WILFREDO
17             MERCADO GABRIEL
18            OTAMENDI NICOLAS
19                 ROJO MARCOS
20              FAZIO FEDERICO
21               ARMANI FRANCO
22               GUZMAN NAHUEL
23                 BEHICH AZIZ
24                KRUSE ROBBIE
25               RISDON JOSHUA
26              MEREDITH JAMES
27                  MOOY AARON
28              MACLAREN JAMIE
29          PETRATOS DIMITRIOS
                ...           
706               KHAZRI WAHBI
707                BEDOUI RAMI
708    BEN YOUSSEF FAKHREDDINE
709              SASSI FERJANI
710           MATHLOUTHI AYMEN
711        BEN MUSTAPHA FAROUK
712           BEN YOUSSEF SYAM
713             NANDEZ NAHITAN
714             TORREIRA LUCAS
715     DE ARRASCAETA GIORGIAN
716               LAXALT DIEGO
717     URRETAVISCAYA JONATHAN
718           VARELA GUILLERMO
719                GODIN DIEGO
720          BENTANCUR RODRIGO
721        PEREIRA MAXIMILIANO
722           MUSLERA FERNANDO
723             SANCHEZ CARLOS
724               SILVA GASTON
725             CACERES MARTIN
726               GIMENEZ JOSE
727           STUANI CRISTHIAN
728             CAVANI EDINSON
729         RODRIGUEZ CRISTIAN
730             CAMPANA MARTIN
731              VECINO MATIAS
732               SILVA MARTIN
733                SUAREZ LUIS
734          GOMEZ MAXIMILIANO
735           COATES SEBASTIAN
Name: FIFA Popular Name, Length: 736, dtype: object

kupa["FIFA Popular Name"]=kupa["FIFA Popular Name"].str.lower() # küçültme işlemini kalıcı hale getirdik.
kupa["FIFA Popular Name"].str.title() # her kelimenin sadece ilk harfini büyütmek için title() metodu kullanılır.

0           Tagliafico Nicolas
1               Pavon Cristian
2               Lanzini Manuel
3               Salvio Eduardo
4                 Messi Lionel
5             Ansaldi Cristian
6                 Biglia Lucas
7                  Banega Ever
8            Mascherano Javier
9                 Dybala Paulo
10               Aguero Sergio
11             Higuain Gonzalo
12              Di Maria Angel
13            Lo Celso Giovani
14            Meza Maximiliano
15                Acuna Marcos
16          Caballero Wilfredo
17             Mercado Gabriel
18            Otamendi Nicolas
19                 Rojo Marcos
20              Fazio Federico
21               Armani Franco
22               Guzman Nahuel
23                 Behich Aziz
24                Kruse Robbie
25               Risdon Joshua
26              Meredith James
27                  Mooy Aaron
28              Maclaren Jamie
29          Petratos Dimitrios
                ...           
706               Khazri Wahbi
707                Bedoui Rami
708    Ben Youssef Fakhreddine
709              Sassi Ferjani
710           Mathlouthi Aymen
711        Ben Mustapha Farouk
712           Ben Youssef Syam
713             Nandez Nahitan
714             Torreira Lucas
715     De Arrascaeta Giorgian
716               Laxalt Diego
717     Urretaviscaya Jonathan
718           Varela Guillermo
719                Godin Diego
720          Bentancur Rodrigo
721        Pereira Maximiliano
722           Muslera Fernando
723             Sanchez Carlos
724               Silva Gaston
725             Caceres Martin
726               Gimenez Jose
727           Stuani Cristhian
728             Cavani Edinson
729         Rodriguez Cristian
730             Campana Martin
731              Vecino Matias
732               Silva Martin
733                Suarez Luis
734          Gomez Maximiliano
735           Coates Sebastian
Name: FIFA Popular Name, Length: 736, dtype: object

kupa["FIFA Popular Name"].str.len() # bir sütundaki her bir değerin uzunluğunu sıralı olarak verir.

0      18
1      14
2      14
3      14
4      12
5      16
6      12
7      11
8      17
9      12
10     13
11     15
12     14
13     16
14     16
15     12
16     18
17     15
18     16
19     11
20     14
21     13
22     13
23     11
24     12
25     13
26     14
27     10
28     14
29     18
       ..
706    12
707    11
708    23
709    13
710    16
711    19
712    16
713    14
714    14
715    22
716    12
717    22
718    16
719    11
720    17
721    19
722    16
723    14
724    12
725    14
726    12
727    16
728    14
729    18
730    14
731    13
732    12
733    11
734    17
735    16
Name: FIFA Popular Name, Length: 736, dtype: int64

kupa["Team"].str.replace("Argentina","ARGENTİNA") # replace metodu sayesinde istediğimiz değeri değiştirebiliyoruz.

0      ARGENTİNA
1      ARGENTİNA
2      ARGENTİNA
3      ARGENTİNA
4      ARGENTİNA
5      ARGENTİNA
6      ARGENTİNA
7      ARGENTİNA
8      ARGENTİNA
9      ARGENTİNA
10     ARGENTİNA
11     ARGENTİNA
12     ARGENTİNA
13     ARGENTİNA
14     ARGENTİNA
15     ARGENTİNA
16     ARGENTİNA
17     ARGENTİNA
18     ARGENTİNA
19     ARGENTİNA
20     ARGENTİNA
21     ARGENTİNA
22     ARGENTİNA
23     Australia
24     Australia
25     Australia
26     Australia
27     Australia
28     Australia
29     Australia
         ...    
706      Tunisia
707      Tunisia
708      Tunisia
709      Tunisia
710      Tunisia
711      Tunisia
712      Tunisia
713      Uruguay
714      Uruguay
715      Uruguay
716      Uruguay
717      Uruguay
718      Uruguay
719      Uruguay
720      Uruguay
721      Uruguay
722      Uruguay
723      Uruguay
724      Uruguay
725      Uruguay
726      Uruguay
727      Uruguay
728      Uruguay
729      Uruguay
730      Uruguay
731      Uruguay
732      Uruguay
733      Uruguay
734      Uruguay
735      Uruguay
Name: Team, Length: 736, dtype: object

kupa["Birth Date"]=kupa["Birth Date"].str.replace(".","/") # tarihlerdeki nokta işaretlerini / işaretiyle 
kupa["Birth Date"]                                         # değiştirip kalıcı hale getirdik

0      31/08/1992
1      21/01/1996
2      15/02/1993
3      13/07/1990
4      24/06/1987
5      20/09/1986
6      30/01/1986
7      29/06/1988
8      08/06/1984
9      15/11/1993
10     02/06/1988
11     10/12/1987
12     14/02/1988
13     09/04/1996
14     15/12/1992
15     28/10/1991
16     28/09/1981
17     18/03/1987
18     12/02/1988
19     20/03/1990
20     17/03/1987
21     16/10/1986
22     10/02/1986
23     16/12/1990
24     05/10/1988
25     27/07/1992
26     05/04/1988
27     15/09/1990
28     29/07/1993
29     10/11/1992
          ...    
706    08/02/1991
707    19/01/1990
708    23/06/1991
709    18/03/1992
710    14/09/1984
711    01/07/1989
712    31/03/1989
713    28/12/1995
714    11/02/1996
715    01/06/1994
716    07/02/1993
717    19/03/1990
718    24/03/1993
719    16/02/1986
720    25/06/1997
721    08/06/1984
722    16/06/1986
723    02/12/1984
724    05/03/1994
725    07/04/1987
726    20/01/1995
727    12/10/1986
728    14/02/1987
729    30/09/1985
730    29/05/1989
731    24/08/1991
732    25/03/1983
733    24/01/1987
734    14/08/1996
735    07/10/1990
Name: Birth Date, Length: 736, dtype: object

kupa["FIFA Popular Name"].str.lower().str.contains("manuel") # belirlediğimiz sütunla istediğimiz kelimeyi içerenleri True olarak geri döndürdü.

0      False
1      False
2       True
3      False
4      False
5      False
6      False
7      False
8      False
9      False
10     False
11     False
12     False
13     False
14     False
15     False
16     False
17     False
18     False
19     False
20     False
21     False
22     False
23     False
24     False
25     False
26     False
27     False
28     False
29     False
       ...  
706    False
707    False
708    False
709    False
710    False
711    False
712    False
713    False
714    False
715    False
716    False
717    False
718    False
719    False
720    False
721    False
722    False
723    False
724    False
725    False
726    False
727    False
728    False
729    False
730    False
731    False
732    False
733    False
734    False
735    False
Name: FIFA Popular Name, Length: 736, dtype: bool

manuel=kupa["FIFA Popular Name"].str.lower().str.contains("manuel") # büyük/küçük harf duyarlılığı vardır.
kupa[manuel] # isminde manuel içerenleri gösteriyoruz burada.

man=kupa["FIFA Popular Name"].str.lower().str.startswith("man")
kupa[man] # man ile başlayanları bize e verdi.

uel=kupa["FIFA Popular Name"].str.lower().str.endswith("uel")
kupa[uel] # sonu verdiğimiz değişkenle bitenleri bulma işlemi

"    hamit s.    ".lstrip() # soldaki boşluğu yok eder

'hamit s.    '

"    hamit s.    ".rstrip() # sağdaki boşluğu alır.

'    hamit s.'

"    hamit s.    ".strip() # sağda ve soldaki boşluğu alır.

'hamit s.'

kupa["FIFA Popular Name"]=kupa["FIFA Popular Name"].str.strip() # sağdaki soldaki bütün boşlukları almak için strip metodu kullanılır
# bu işlem tüm sütunlar için yapılmalıdır, veri hatalarına sebep olmamak için.

kupa["Club"]=kupa["Club"].str.strip()

kupa.index.str.strip() # bu hatanın nedeni index belirtmememiztir. Çözüm aşağıdaki gibi index belirterek sağlanır.

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-35-d865f0f0111a> in <module>
----> 1 kupa.index.str.strip()

~\Anaconda3\lib\site-packages\pandas\core\accessor.py in __get__(self, obj, cls)
    131             # we're accessing the attribute of the class, i.e., Dataset.geo
    132             return self._accessor
--> 133         accessor_obj = self._accessor(obj)
    134         # Replace the property with the accessor object. Inspired by:
    135         # http://www.pydanny.com/cached-property.html

~\Anaconda3\lib\site-packages\pandas\core\strings.py in __init__(self, data)
   1893 
   1894     def __init__(self, data):
-> 1895         self._validate(data)
   1896         self._is_categorical = is_categorical_dtype(data)
   1897 

~\Anaconda3\lib\site-packages\pandas\core\strings.py in _validate(data)
   1931                            "(i.e. inferred_type is 'string', 'unicode' or "
   1932                            "'mixed')")
-> 1933                 raise AttributeError(message)
   1934             if data.nlevels > 1:
   1935                 message = ("Can only use .str accessor with Index, not "

AttributeError: Can only use .str accessor with string values (i.e. inferred_type is 'string', 'unicode' or 'mixed')

kupa=kupa.set_index(keys="Team") # index sütunu belirleme işlemi
kupa

kupa.columns=kupa.columns.str.strip().str.upper() # tün sütun başlıklarını boşluklardan kurtardık. Bu ilerde yapılabilecek işlemler için önemli bir ayrıntıdır.
kupa

kupa["FIFA POPULAR NAME"].str.split(" ") # burda popular name içindki kelimeleri " " boşluk ile bölüyoruz.

Team
Argentina          [tagliafico, nicolas]
Argentina              [pavon, cristian]
Argentina              [lanzini, manuel]
Argentina              [salvio, eduardo]
Argentina                [messi, lionel]
Argentina            [ansaldi, cristian]
Argentina                [biglia, lucas]
Argentina                 [banega, ever]
Argentina           [mascherano, javier]
Argentina                [dybala, paulo]
Argentina               [aguero, sergio]
Argentina             [higuain, gonzalo]
Argentina             [di, maria, angel]
Argentina           [lo, celso, giovani]
Argentina            [meza, maximiliano]
Argentina                [acuna, marcos]
Argentina          [caballero, wilfredo]
Argentina             [mercado, gabriel]
Argentina            [otamendi, nicolas]
Argentina                 [rojo, marcos]
Argentina              [fazio, federico]
Argentina               [armani, franco]
Argentina               [guzman, nahuel]
Australia                 [behich, aziz]
Australia                [kruse, robbie]
Australia               [risdon, joshua]
Australia              [meredith, james]
Australia                  [mooy, aaron]
Australia              [maclaren, jamie]
Australia          [petratos, dimitrios]
                        ...             
Tunisia                  [khazri, wahbi]
Tunisia                   [bedoui, rami]
Tunisia      [ben, youssef, fakhreddine]
Tunisia                 [sassi, ferjani]
Tunisia              [mathlouthi, aymen]
Tunisia          [ben, mustapha, farouk]
Tunisia             [ben, youssef, syam]
Uruguay                [nandez, nahitan]
Uruguay                [torreira, lucas]
Uruguay       [de, arrascaeta, giorgian]
Uruguay                  [laxalt, diego]
Uruguay        [urretaviscaya, jonathan]
Uruguay              [varela, guillermo]
Uruguay                   [godin, diego]
Uruguay             [bentancur, rodrigo]
Uruguay           [pereira, maximiliano]
Uruguay              [muslera, fernando]
Uruguay                [sanchez, carlos]
Uruguay                  [silva, gaston]
Uruguay                [caceres, martin]
Uruguay                  [gimenez, jose]
Uruguay              [stuani, cristhian]
Uruguay                [cavani, edinson]
Uruguay            [rodriguez, cristian]
Uruguay                [campana, martin]
Uruguay                 [vecino, matias]
Uruguay                  [silva, martin]
Uruguay                   [suarez, luis]
Uruguay             [gomez, maximiliano]
Uruguay              [coates, sebastian]
Name: FIFA POPULAR NAME, Length: 736, dtype: object

kupa["FIFA POPULAR NAME"].str.split(" ").str.get(0).str.title() # sütunun değerlerini split ile böldük ve 0. kelimeyi aldık. title metodu ile de ilk harfi büyük yaptık.

Team
Argentina       Tagliafico
Argentina            Pavon
Argentina          Lanzini
Argentina           Salvio
Argentina            Messi
Argentina          Ansaldi
Argentina           Biglia
Argentina           Banega
Argentina       Mascherano
Argentina           Dybala
Argentina           Aguero
Argentina          Higuain
Argentina               Di
Argentina               Lo
Argentina             Meza
Argentina            Acuna
Argentina        Caballero
Argentina          Mercado
Argentina         Otamendi
Argentina             Rojo
Argentina            Fazio
Argentina           Armani
Argentina           Guzman
Australia           Behich
Australia            Kruse
Australia           Risdon
Australia         Meredith
Australia             Mooy
Australia         Maclaren
Australia         Petratos
                 ...      
Tunisia             Khazri
Tunisia             Bedoui
Tunisia                Ben
Tunisia              Sassi
Tunisia         Mathlouthi
Tunisia                Ben
Tunisia                Ben
Uruguay             Nandez
Uruguay           Torreira
Uruguay                 De
Uruguay             Laxalt
Uruguay      Urretaviscaya
Uruguay             Varela
Uruguay              Godin
Uruguay          Bentancur
Uruguay            Pereira
Uruguay            Muslera
Uruguay            Sanchez
Uruguay              Silva
Uruguay            Caceres
Uruguay            Gimenez
Uruguay             Stuani
Uruguay             Cavani
Uruguay          Rodriguez
Uruguay            Campana
Uruguay             Vecino
Uruguay              Silva
Uruguay             Suarez
Uruguay              Gomez
Uruguay             Coates
Name: FIFA POPULAR NAME, Length: 736, dtype: object

kupa["FIFA POPULAR NAME"].str.split(" ").str.get(0).str.title().value_counts() # Bir önceki kod satırında olan açıklamaya 
# ek olarak burda valuecounts() metodu ile hangi isimden kaç tane olduğunu buluyoruz.

Rodriguez           6
Ben                 5
Mohamed             5
Kim                 5
Ahmed               3
Abdullah            3
Gomez               3
Mohammed            3
El                  3
De                  3
Ndiaye              3
Lee                 3
Silva               3
Sanchez             3
Aquino              2
Murillo             2
Quintero            2
Sigurdsson          2
Jorgensen           2
Ricardo             2
Guzman              2
Thiago              2
Torres              2
Kalinic             2
Dembele             2
Ali                 2
Miranchuk           2
Joao                2
Amrabat             2
Gudmundsson         2
                   ..
Marcelo             1
Jang                1
Cionek              1
Alexander-Arnold    1
Varela              1
Forsberg            1
Milik               1
Sherif              1
Rohden              1
Welbeck             1
Navas               1
Koke                1
Gunnarsson          1
Kvist               1
Campbell            1
Shibasaki           1
Fajr                1
Gallese             1
Meunier             1
Kurzawa             1
Cheshmi             1
Azpilicueta         1
Ochoa               1
Brozovic            1
Cueva               1
Gavranovic          1
Gonzalez            1
Pedro               1
Behich              1
Cartagena           1
Name: FIFA POPULAR NAME, Length: 669, dtype: int64

kupa["FIFA POPULAR NAME"].str.split(" ",expand=True,n=1) # expand parametresi ile bölme işleminden sonra farklı sütunlara alma işlemi yapılıyor. n=1 ile 0-1 aralığında yani 2 ye bölerek göster diyoruz.

kupa[["İsim", "Soyisim"]]=kupa["FIFA POPULAR NAME"].str.split(" ",expand=True,n=1) # isim ve soyisim adında yeni 2 tane sütun 
# ekledik. Ve az önceki işlemde olduğu gibi bir sütunu ikiye ayırarark bu sütunlara yerleştirdik.
kupa

	Team	#	Pos.	FIFA Popular Name	Birth Date	Shirt Name	Club	Height	Weight
2	Argentina	15	MF	lanzini manuel	15/02/1993	LANZINI	West Ham United FC (ENG)	167	66
275	Germany	1	GK	neuer manuel	27/03/1986	NEUER	FC Bayern München (GER)	193	93
407	Morocco	4	DF	da costa manuel	06/05/1986	DA COSTA	Istanbul Başakşehir FK (TUR)	187	78
513	Portugal	4	MF	manuel fernandes	05/02/1986	M. FERNANDES	FC Lokomotiv Moscow (RUS)	174	69
686	Switzerland	5	DF	akanji manuel	19/07/1995	AKANJI	Borussia Dortmund (GER)	186	85

	Team	#	Pos.	FIFA Popular Name	Birth Date	Shirt Name	Club	Height	Weight
158	Croatia	17	FW	mandzukic mario	21/05/1986	MANDŽUKIĆ	Juventus FC (ITA)	190	85
249	France	16	GK	mandanda steve	28/03/1985	MANDANDA	Olympique Marseille (FRA)	187	88
513	Portugal	4	MF	manuel fernandes	05/02/1986	M. FERNANDES	FC Lokomotiv Moscow (RUS)	174	69
560	Saudi Arabia	2	DF	mansour alharbi	19/10/1987	MANSOUR	Al Ahli SC (KSA)	173	68
577	Senegal	10	FW	mane sadio	10/04/1992	MANE	Liverpool FC (ENG)	175	69

	Team	#	Pos.	FIFA Popular Name	Birth Date	Shirt Name	Club	Height	Weight
2	Argentina	15	MF	lanzini manuel	15/02/1993	LANZINI	West Ham United FC (ENG)	167	66
22	Argentina	1	GK	guzman nahuel	10/02/1986	GUZMÁN	Tigres UANL (MEX)	192	90
102	Colombia	19	FW	borja miguel	26/01/1993	M. BORJA	SE Palmeiras (BRA)	183	74
245	France	5	DF	umtiti samuel	14/11/1993	UMTITI	FC Barcelona (ESP)	183	84
275	Germany	1	GK	neuer manuel	27/03/1986	NEUER	FC Bayern München (GER)	193	93
282	Iceland	3	MF	fridjonsson samuel	22/02/1996	FRIDJÓNSSON	Valerenga IF (NOR)	185	78
376	Mexico	7	MF	layun miguel	25/06/1988	M. LAYÚN	Sevilla FC (ESP)	180	72
407	Morocco	4	DF	da costa manuel	06/05/1986	DA COSTA	Istanbul Başakşehir FK (TUR)	187	78
469	Peru	6	DF	trauco miguel	25/08/1992	TRAUCO	CR Flamengo (BRA)	169	74
472	Peru	5	DF	araujo miguel	24/10/1994	ARAUJO	Alianza Lima (PER)	178	77
686	Switzerland	5	DF	akanji manuel	19/07/1995	AKANJI	Borussia Dortmund (GER)	186	85

Python Pandas’ta Dataframe-Text Verileri

Bir cevap yazın Cevabı iptal et

Son Yazılar

Kategoriler

Arşivler

	Team	#	Pos.	FIFA Popular Name	Birth Date	Shirt Name	Club	Height	Weight
0	Argentina	3	DF	TAGLIAFICO Nicolas	31.08.1992	TAGLIAFICO	AFC Ajax (NED)	169	65
1	Argentina	22	MF	PAVON Cristian	21.01.1996	PAVÓN	CA Boca Juniors (ARG)	169	65
2	Argentina	15	MF	LANZINI Manuel	15.02.1993	LANZINI	West Ham United FC (ENG)	167	66
3	Argentina	18	DF	SALVIO Eduardo	13.07.1990	SALVIO	SL Benfica (POR)	167	69
4	Argentina	10	FW	MESSI Lionel	24.06.1987	MESSI	FC Barcelona (ESP)	170	72
5	Argentina	4	DF	ANSALDI Cristian	20.09.1986	ANSALDI	Torino FC (ITA)	181	73
6	Argentina	5	MF	BIGLIA Lucas	30.01.1986	BIGLIA	AC Milan (ITA)	175	73
7	Argentina	7	MF	BANEGA Ever	29.06.1988	BANEGA	Sevilla FC (ESP)	175	73
8	Argentina	14	DF	MASCHERANO Javier	08.06.1984	MASCHERANO	Hebei China Fortune FC (CHN)	174	73
9	Argentina	21	FW	DYBALA Paulo	15.11.1993	DYBALA	Juventus FC (ITA)	177	73
10	Argentina	19	FW	AGUERO Sergio	02.06.1988	AGÜERO	Manchester City FC (ENG)	172	74
11	Argentina	9	FW	HIGUAIN Gonzalo	10.12.1987	HIGUAÍN	Juventus FC (ITA)	184	75
12	Argentina	11	MF	DI MARIA Angel	14.02.1988	DI MARÍA	Paris Saint-Germain FC (FRA)	178	75
13	Argentina	20	MF	LO CELSO Giovani	09.04.1996	LO CELSO	Paris Saint-Germain FC (FRA)	177	75
14	Argentina	13	MF	MEZA Maximiliano	15.12.1992	MEZA	CA Independiente (ARG)	180	76
15	Argentina	8	DF	ACUNA Marcos	28.10.1991	ACUÑA	Sporting CP (POR)	172	77
16	Argentina	23	GK	CABALLERO Wilfredo	28.09.1981	CABALLERO	Chelsea FC (ENG)	186	80
17	Argentina	2	DF	MERCADO Gabriel	18.03.1987	MERCADO	Sevilla FC (ESP)	181	81
18	Argentina	17	DF	OTAMENDI Nicolas	12.02.1988	OTAMENDI	Manchester City FC (ENG)	181	81
19	Argentina	16	DF	ROJO Marcos	20.03.1990	ROJO	Manchester United FC (ENG)	189	82
20	Argentina	6	DF	FAZIO Federico	17.03.1987	FAZIO	AS Roma (ITA)	199	85
21	Argentina	12	GK	ARMANI Franco	16.10.1986	ARMANI	CA River Plate (ARG)	189	85
22	Argentina	1	GK	GUZMAN Nahuel	10.02.1986	GUZMÁN	Tigres UANL (MEX)	192	90
23	Australia	16	DF	BEHICH Aziz	16.12.1990	BEHICH	Bursaspor (TUR)	170	63
24	Australia	10	FW	KRUSE Robbie	05.10.1988	KRUSE	VfL Bochum (GER)	180	66
25	Australia	19	DF	RISDON Joshua	27.07.1992	RISDON	WS Wanderers FC (AUS)	169	70
26	Australia	3	DF	MEREDITH James	05.04.1988	MEREDITH	Millwall FC (ENG)	179	71
27	Australia	13	MF	MOOY Aaron	15.09.1990	MOOY	Huddersfield Town FC (ENG)	173	72
28	Australia	14	FW	MacLAREN Jamie	29.07.1993	MACLAREN	Hibernian FC (SCO)	178	72
29	Australia	21	FW	PETRATOS Dimitrios	10.11.1992	PETRATOS	Newcastle United Jets FC (AUS)	176	72
…	…	…	…	…	…	…	…	…	…
706	Tunisia	10	FW	KHAZRI Wahbi	08.02.1991	KHAZRI	Stade Rennais FC (FRA)	182	76
707	Tunisia	6	DF	BEDOUI Rami	19.01.1990	BEDOUI	Étoile du Sahel (TUN)	187	77
708	Tunisia	8	FW	BEN YOUSSEF Fakhreddine	23.06.1991	BEN YOUSSEF .F	Al Ittifaq FC (KSA)	189	80
709	Tunisia	13	MF	SASSI Ferjani	18.03.1992	SASSI	Al Nassr FC (KSA)	186	80
710	Tunisia	16	GK	MATHLOUTHI Aymen	14.09.1984	MATHLOUTHI .A	Al Batin FC (KSA)	182	84
711	Tunisia	1	GK	BEN MUSTAPHA Farouk	01.07.1989	BEN MUSTAPHA	Al Shabab FC (KSA)	192	85
712	Tunisia	2	DF	BEN YOUSSEF Syam	31.03.1989	BEN YOUSSEF .S	Kasimpasa SK (TUR)	189	87
713	Uruguay	8	MF	NANDEZ Nahitan	28.12.1995	NANDEZ	CA Boca Juniors (ARG)	171	61
714	Uruguay	14	MF	TORREIRA Lucas	11.02.1996	TORREIRA	UC Sampdoria (ITA)	168	61
715	Uruguay	10	FW	DE ARRASCAETA Giorgian	01.06.1994	DE ARRASCAETA	Cruzeiro EC (BRA)	172	64
716	Uruguay	17	MF	LAXALT Diego	07.02.1993	LAXALT	Genoa CFC (ITA)	178	66
717	Uruguay	20	FW	URRETAVISCAYA Jonathan	19.03.1990	URRETAVISCAYA	CF Monterrey (MEX)	172	66
718	Uruguay	4	DF	VARELA Guillermo	24.03.1993	VARELA	CA Penarol (URU)	173	70
719	Uruguay	3	DF	GODIN Diego	16.02.1986	GODIN	Atletico Madrid (ESP)	185	73
720	Uruguay	6	MF	BENTANCUR Rodrigo	25.06.1997	BENTANCUR	Juventus FC (ITA)	187	73
721	Uruguay	16	DF	PEREIRA Maximiliano	08.06.1984	M. PEREIRA	FC Porto (POR)	173	73
722	Uruguay	1	GK	MUSLERA Fernando	16.06.1986	MUSLERA	Galatasaray SK (TUR)	190	74
723	Uruguay	5	MF	SANCHEZ Carlos	02.12.1984	SANCHEZ	CF Monterrey (MEX)	171	74
724	Uruguay	13	DF	SILVA Gaston	05.03.1994	G. SILVA	CA Independiente (ARG)	185	74
725	Uruguay	22	DF	CACERES Martin	07.04.1987	CACERES	SS Lazio (ITA)	178	75
726	Uruguay	2	DF	GIMENEZ Jose	20.01.1995	J.M. GIMENEZ	Atletico Madrid (ESP)	185	77
727	Uruguay	11	FW	STUANI Cristhian	12.10.1986	STUANI	Girona FC (ESP)	186	78
728	Uruguay	21	FW	CAVANI Edinson	14.02.1987	CAVANI	Paris Saint-Germain FC (FRA)	188	78
729	Uruguay	7	MF	RODRIGUEZ Cristian	30.09.1985	C. RODRIGUEZ	CA Penarol (URU)	178	79
730	Uruguay	12	GK	CAMPANA Martin	29.05.1989	CAMPAÑA	CA Independiente (ARG)	184	79
731	Uruguay	15	MF	VECINO Matias	24.08.1991	VECINO	FC Internazionale (ITA)	189	80
732	Uruguay	23	GK	SILVA Martin	25.03.1983	M. SILVA	CR Vasco da Gama (BRA)	187	82
733	Uruguay	9	FW	SUAREZ Luis	24.01.1987	SUAREZ	FC Barcelona (ESP)	182	85
734	Uruguay	18	FW	GOMEZ Maximiliano	14.08.1996	M. GOMEZ	Celta Vigo (ESP)	186	85
735	Uruguay	19	DF	COATES Sebastian	07.10.1990	COATES	Sporting CP (POR)	196	89

Related posts

Bir cevap yazın Cevabı iptal et