Combinando conjuntos de dados
Analisando a Atividade Policial com pandas
Kevin Markham
Founder, Data School
apple
date time price
date_and_time
2018-02-14 09:30:00 2/14/18 9:30 163.04
2018-02-14 16:00:00 2/14/18 16:00 167.37
2018-02-15 09:30:00 2/15/18 9:30 169.79
2018-02-15 16:00:00 2/15/18 16:00 172.99
apple.reset_index(inplace=True)apple
date_and_time date time price
0 2018-02-14 09:30:00 2/14/18 9:30 163.04
1 2018-02-14 16:00:00 2/14/18 16:00 167.37
2 2018-02-15 09:30:00 2/15/18 9:30 169.79
3 2018-02-15 16:00:00 2/15/18 16:00 172.99
Preparando o segundo DataFrame
high_low
DATE HIGH LOW
0 2/14/18 167.54 162.88
1 2/15/18 173.09 169.00
2 2/16/18 174.82 171.77
high = high_low[['DATE', 'HIGH']]high
DATE HIGH
0 2/14/18 167.54
1 2/15/18 173.09
2 2/16/18 174.82
Combinando os DataFrames
apple_high = pd.merge(left=apple, right=high,
left_on='date', right_on='DATE',
how='left')
left=apple: DataFrame esquerdoright=high: DataFrame direitoleft_on='date': Coluna-chave no DataFrame esquerdoright_on='DATE': Coluna-chave no DataFrame direitohow='left': Tipo de junção
apple_high
date_and_time date time price DATE HIGH
0 2018-02-14 09:30:00 2/14/18 9:30 163.04 2/14/18 167.54
1 2018-02-14 16:00:00 2/14/18 16:00 167.37 2/14/18 167.54
2 2018-02-15 09:30:00 2/15/18 9:30 169.79 2/15/18 173.09
3 2018-02-15 16:00:00 2/15/18 16:00 172.99 2/15/18 173.09
apple
date_and_time date time price
0 2018-02-14 09:30:00 2/14/18 9:30 163.04
1 2018-02-14 16:00:00 2/14/18 16:00 167.37
2 2018-02-15 09:30:00 2/15/18 9:30 169.79
3 2018-02-15 16:00:00 2/15/18 16:00 172.99
high
DATE HIGH
0 2/14/18 167.54
1 2/15/18 173.09
2 2/16/18 174.82
Definindo o índice
apple_high.set_index('date_and_time', inplace=True)apple_high
date time price DATE HIGH
date_and_time
2018-02-14 09:30:00 2/14/18 9:30 163.04 2/14/18 167.54
2018-02-14 16:00:00 2/14/18 16:00 167.37 2/14/18 167.54
2018-02-15 09:30:00 2/15/18 9:30 169.79 2/15/18 173.09
2018-02-15 16:00:00 2/15/18 16:00 172.99 2/15/18 173.09
Vamos praticar!
Analisando a Atividade Policial com pandas
