Lernen That's All? | Preprocessing Data: Part II

So, seems like all the columns are fine now. Let's double-check if we have converted dates properly.


              123456789101112131415
            
# 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')

# Displaying first four dates before converting
print(df['Date'].head(4))

# Change column type
df['Date'] = pd.to_datetime(df['Date'], dayfirst = True)

# Displaying first four dates and dtypes of dataframe
print(df['Date'].head(4))
print(df.dtypes)

Yes, this time everything seems to be fine. Dtypes of the dataframe are appropriate, so we are ready to make some analysis and visualizing!

War alles klar?

Danke für Ihr Feedback!

Abschnitt 2. Kapitel 6

Fragen Sie AI

Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen

Suggested prompts:

Fragen Sie mich Fragen zu diesem Thema

Zusammenfassen Sie dieses Kapitel

Zeige reale Beispiele

Awesome!

Completion rate improved to 3.45

Swipe um das Menü anzuzeigen

So, seems like all the columns are fine now. Let's double-check if we have converted dates properly.


              123456789101112131415
            
# 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')

# Displaying first four dates before converting
print(df['Date'].head(4))

# Change column type
df['Date'] = pd.to_datetime(df['Date'], dayfirst = True)

# Displaying first four dates and dtypes of dataframe
print(df['Date'].head(4))
print(df.dtypes)

Yes, this time everything seems to be fine. Dtypes of the dataframe are appropriate, so we are ready to make some analysis and visualizing!

War alles klar?

Danke für Ihr Feedback!

Abschnitt 2. Kapitel 6