Date Range
Good, we know the best selling stores for entire date range. But how wide it is? Let's find out.
Since we convert the 'Date'
column into the datetime
type, we can apply different methods on it, like .min()
or .max()
. They will return the earliest and the latest dates in the column.
123456789# Loading the library import pandas as pd # Reading the data df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/72be5dde-f3e6-4c40-8881-e1d97ae31287/shops_data3.csv') df['Date'] = pd.to_datetime(df['Date'], dayfirst = True) # Inspecting the 'Date' column print(df['Date'].min())
For the following question, feel free to edit the code above if necessary.
Grazie per i tuoi commenti!
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 3.45
Date Range
Scorri per mostrare il menu
Good, we know the best selling stores for entire date range. But how wide it is? Let's find out.
Since we convert the 'Date'
column into the datetime
type, we can apply different methods on it, like .min()
or .max()
. They will return the earliest and the latest dates in the column.
123456789# Loading the library import pandas as pd # Reading the data df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/72be5dde-f3e6-4c40-8881-e1d97ae31287/shops_data3.csv') df['Date'] = pd.to_datetime(df['Date'], dayfirst = True) # Inspecting the 'Date' column print(df['Date'].min())
For the following question, feel free to edit the code above if necessary.
Grazie per i tuoi commenti!