import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
url = 'https://raw.githubusercontent.com/alura-cursos/python_dados/refs/heads/main/Dados/contagem_bicicletas.csv'
df = pd.read_csv(url)
df.head()
df['data_hora'] = pd.to_datetime(df['data_hora'])
df['Data'] = df['data_hora'].dt.date
df_bike = df.groupby('Data')['contagem'].sum().reset_index()
df_bike
