Aprenda 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!

Tudo estava claro?

Obrigado pelo seu feedback!

Seção 2. Capítulo 6

Pergunte à IA

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

Suggested prompts:

Pergunte-me perguntas sobre este assunto

Resumir este capítulo

Mostrar exemplos do mundo real

Deslize para mostrar o menu

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!

Tudo estava claro?

Obrigado pelo seu feedback!

Seção 2. Capítulo 6