DCC1

#Importando as bibliotecas que iremos usar import pandas as pd

#Importando os nossos dataframes df_jogadores = pd.read_csv('/work/Jogadores/players.csv') df_ataque = pd.read_csv('/work/Jogadores/tbl_player_attacking.csv') df_mentalidade = pd.read_csv('/work/Jogadores/tbl_player_mentality.csv') df_movimentacao = pd.read_csv('/work/Jogadores/tbl_player_movement.csv') df_poder = pd.read_csv('/work/Jogadores/tbl_player_power.csv') df_habilidade = pd.read_csv('/work/Jogadores/tbl_player_skill.csv') df_especialidades = pd.read_csv('/work/Jogadores/tbl_player_specialities.csv') df_ = pd.read_csv('/work/Jogadores/tbl_player_skill.csv')

#juntando os dataframes df_dcc1 = df_jogadores.merge(df_ataque,on='int_player_id',how='left') df_dcc2 = df_dcc1.merge(df_mentalidade,on='int_player_id',how='left') df_dcc3 = df_dcc2.merge(df_movimentacao, on='int_player_id',how='left') df_dcc4 = df_dcc3.merge(df_poder, on='int_player_id',how='left') df_dcc5 = df_dcc4.merge(df_habilidade, on='int_player_id',how='left') df_dcc = df_dcc5.merge(df_especialidades, on='int_player_id',how='left') df_dcc.head(5)

int_player_idint64

str_player_nameobject

0

1

Lionel Andrés Messi Cuccittini

1

Lionel Andrés Messi Cuccittini

2

1

Lionel Andrés Messi Cuccittini

3

1

Lionel Andrés Messi Cuccittini

4

1

Lionel Andrés Messi Cuccittini

#Verificando de as colunas estão completas df_dcc.info() #str_player_speciality_y, int_speciality_id e str_trait não estão com o mesmo numero de linha das outras colunas

<class 'pandas.core.frame.DataFrame'>
Int64Index: 19372 entries, 0 to 19371
Data columns (total 89 columns):
 #   Column                         Non-Null Count  Dtype  
---  ------                         --------------  -----  
 0   int_player_id                  19372 non-null  int64  
 1   str_player_name                19372 non-null  object 
 2   str_positions                  19372 non-null  object 
 3   dt_date_of_birth               19372 non-null  object 
 4   int_height                     19372 non-null  int64  
 5   int_weight                     19372 non-null  int64  
 6   int_overall_rating             19372 non-null  int64  
 7   int_potential_rating           19372 non-null  int64  
 8   str_best_position              19372 non-null  object 
 9   int_best_overall_rating        19372 non-null  int64  
 10  int_value                      19372 non-null  int64  
 11  int_wage                       19372 non-null  int64  
 12  int_team_id                    19134 non-null  float64
 13  str_nationality                19372 non-null  object 
 14  int_crossing_x                 19372 non-null  int64  
 15  int_finishing_x                19372 non-null  int64  
 16  int_heading_accuracy_x         19372 non-null  int64  
 17  int_short_passing_x            19372 non-null  int64  
 18  int_volleys_x                  19372 non-null  int64  
 19  int_defensive_awareness        19372 non-null  int64  
 20  int_standing_tackle            19372 non-null  int64  
 21  int_sliding_tackle             19372 non-null  int64  
 22  int_diving                     19372 non-null  int64  
 23  int_handling                   19372 non-null  int64  
 24  int_kicking                    19372 non-null  int64  
 25  int_gk_positioning             19372 non-null  int64  
 26  int_reflexes                   19372 non-null  int64  
 27  int_aggression_x               19372 non-null  int64  
 28  int_interceptions_x            19372 non-null  int64  
 29  int_positioning_x              19372 non-null  int64  
 30  int_vision_x                   19372 non-null  int64  
 31  int_penalties_x                19372 non-null  int64  
 32  int_composure_x                19372 non-null  int64  
 33  int_acceleration_x             19372 non-null  int64  
 34  int_sprint_speed_x             19372 non-null  int64  
 35  int_agility_x                  19372 non-null  int64  
 36  int_reactions_x                19372 non-null  int64  
 37  int_balance_x                  19372 non-null  int64  
 38  int_shot_power_x               19372 non-null  int64  
 39  int_jumping_x                  19372 non-null  int64  
 40  int_stamina_x                  19372 non-null  int64  
 41  int_strength_x                 19372 non-null  int64  
 42  int_long_shots_x               19372 non-null  int64  
 43  str_preferred_foot             19372 non-null  object 
 44  int_weak_foot                  19372 non-null  int64  
 45  int_skill_moves                19372 non-null  int64  
 46  int_international_reputations  19372 non-null  int64  
 47  str_work_rate                  19372 non-null  object 
 48  str_body_type                  19372 non-null  object 
 49  int_dribbling_x                19372 non-null  int64  
 50  int_curve_x                    19372 non-null  int64  
 51  int_fk_accuracy_x              19372 non-null  int64  
 52  int_long_passing_x             19372 non-null  int64  
 53  int_ball_control_x             19372 non-null  int64  
 54  str_player_speciality_x        1786 non-null   object 
 55  str_trait                      8825 non-null   object 
 56  int_attacking_id               19372 non-null  int64  
 57  int_crossing_y                 19372 non-null  int64  
 58  int_finishing_y                19372 non-null  int64  
 59  int_heading_accuracy_y         19372 non-null  int64  
 60  int_short_passing_y            19372 non-null  int64  
 61  int_volleys_y                  19372 non-null  int64  
 62  int_mentality_id               19372 non-null  int64  
 63  int_aggression_y               19372 non-null  int64  
 64  int_interceptions_y            19372 non-null  int64  
 65  int_positioning_y              19372 non-null  int64  
 66  int_vision_y                   19372 non-null  int64  
 67  int_penalties_y                19372 non-null  int64  
 68  int_composure_y                19372 non-null  int64  
 69  int_movement_id                19372 non-null  int64  
 70  int_acceleration_y             19372 non-null  int64  
 71  int_sprint_speed_y             19372 non-null  int64  
 72  int_agility_y                  19372 non-null  int64  
 73  int_reactions_y                19372 non-null  int64  
 74  int_balance_y                  19372 non-null  int64  
 75  int_power_id                   19372 non-null  int64  
 76  int_shot_power_y               19372 non-null  int64  
 77  int_jumping_y                  19372 non-null  int64  
 78  int_stamina_y                  19372 non-null  int64  
 79  int_strength_y                 19372 non-null  int64  
 80  int_long_shots_y               19372 non-null  int64  
 81  int_skill_id                   19372 non-null  int64  
 82  int_dribbling_y                19372 non-null  int64  
 83  int_curve_y                    19372 non-null  int64  
 84  int_fk_accuracy_y              19372 non-null  int64  
 85  int_long_passing_y             19372 non-null  int64  
 86  int_ball_control_y             19372 non-null  int64  
 87  int_speciality_id              1786 non-null   float64
 88  str_player_speciality_y        1786 non-null   object 
dtypes: float64(2), int64(76), object(11)
memory usage: 13.3+ MB

#Excluindo valores duplicados df_dcc.drop_duplicates(inplace=True) #Sem itens duplicados

df_dcc['str_positions'].head()

#Lista de todas as posições list(df_dcc['str_positions'].drop_duplicates())

#Filtrando jogadores apenas do ataque posicao_ataque = ['RW, ST, CF', 'ST, LW', 'LW, CAM', 'ST', 'ST, LW, RW', 'RW', 'LW', 'CF, ST', 'CF, CAM', 'LW, RW', 'LM, CF', 'LW, ST', 'RM, CF, CAM', 'CF', 'RW, LW', 'RM, LM, RW', 'CAM, RM, RW', 'CAM, CF, ST', 'CAM, RW', 'LW, CF', 'CAM, CF', 'CF, LW, CAM', 'ST, RW', 'LW, CAM, RW', 'RW, LW, CAM', 'ST, CAM', 'ST, CF', 'CF, ST, CAM', 'CAM, LW, ST', 'CAM, LW', 'RW, CAM', 'ST, RW, LW', 'CAM', 'CAM, ST', 'LW, RW, CAM', 'LW, ST, CM', 'RW, ST, LW', 'CF, CAM, ST', 'RW, ST', 'ST, CAM, RW', 'CF, LW, RW', 'CAM, ST, CF', 'ST, LW, CAM', 'CF, RW', 'LW, RW, CF', 'CF, CAM, LW', 'CF, ST, RW', 'LW, CF, ST', 'LW, RW, ST', 'RW, LW, ST', 'ST, CF, CAM', 'CF, ST, LW', 'CAM, CF, RW', 'LW, RW, RM', 'CF, LW', 'RW, LW, CF', 'CF, LW, ST', 'CAM, ST, LW', 'LW, ST, RW', 'CAM, RW, ST', 'CF, CAM, RW', 'ST, RW, CAM', 'RW, CF', 'CAM, RW, LW', 'LW, CAM, CF', 'LW, CF, CAM', 'ST, CF, LW', 'CAM, LW, RW', 'RW, ST, CAM', 'ST, CAM, CF', 'LW, CAM, ST', 'ST, CAM, LW', 'CAM, ST, RW', 'ST, LW, CF', 'LW, ST, CAM', 'RW, CAM, LW', 'ST, CF, RW', 'RW, CF, LW', 'CAM, RW, CF', 'RW, CF, CAM', 'LW, CF, RW', 'ST, RW, CF', 'CAM, LW, CF']

#Aplicando o filtro selecao = df_dcc['str_positions'].isin(posicao_ataque) df_dcc_atk = df_dcc[selecao] df_dcc_atk

int_player_idint64

1 - 18999

str_player_nameobject

Neymar da Silva Santos Júnior0.2%

Lionel Andrés Messi Cuccittini0.2%

3541 others99.6%

0

1

Lionel Andrés Messi Cuccittini

1

Lionel Andrés Messi Cuccittini

2

1

Lionel Andrés Messi Cuccittini

3

1

Lionel Andrés Messi Cuccittini

4

1

Lionel Andrés Messi Cuccittini

5

1

Lionel Andrés Messi Cuccittini

6

2

Cristiano Ronaldo dos Santos Aveiro

7

2

Cristiano Ronaldo dos Santos Aveiro

8

2

Cristiano Ronaldo dos Santos Aveiro

9

2

Cristiano Ronaldo dos Santos Aveiro

#Tamanho do dataframe original df_dcc.shape[0]

#Tamanho do dataframe pegando apenas os atacantes df_dcc_atk.shape[0]

#Ajeitando o index df_dcc_atk.index = range(df_dcc_atk.shape[0]) df_dcc_atk

int_player_idint64

1 - 18999

str_player_nameobject

Neymar da Silva Santos Júnior0.2%

Lionel Andrés Messi Cuccittini0.2%

3541 others99.6%

0

1

Lionel Andrés Messi Cuccittini

1

Lionel Andrés Messi Cuccittini

2

1

Lionel Andrés Messi Cuccittini

3

1

Lionel Andrés Messi Cuccittini

4

1

Lionel Andrés Messi Cuccittini

5

1

Lionel Andrés Messi Cuccittini

6

2

Cristiano Ronaldo dos Santos Aveiro

7

2

Cristiano Ronaldo dos Santos Aveiro

8

2

Cristiano Ronaldo dos Santos Aveiro

9

2

Cristiano Ronaldo dos Santos Aveiro

# Tirando os nomes repetidos list(df_dcc_atk['int_player_id'].drop_duplicates())

int_player_idint64

1 - 18999

str_player_nameobject

Neymar da Silva Santos Júnior0.2%

Lionel Andrés Messi Cuccittini0.2%

3541 others99.6%

0

1

Lionel Andrés Messi Cuccittini

1

Lionel Andrés Messi Cuccittini

2

1

Lionel Andrés Messi Cuccittini

3

1

Lionel Andrés Messi Cuccittini

4

1

Lionel Andrés Messi Cuccittini

5

1

Lionel Andrés Messi Cuccittini

6

2

Cristiano Ronaldo dos Santos Aveiro

7

2

Cristiano Ronaldo dos Santos Aveiro

8

2

Cristiano Ronaldo dos Santos Aveiro

9

2

Cristiano Ronaldo dos Santos Aveiro