Analyzing Columns
Let's inspect how many object
columns are left.
12345678# 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_data2.csv') # Checking columns types print(df.dtypes)
As you can see, only 2 object
columns remain. So, what's wrong with the 'Weekly_Sales'
column?
12345678# 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_data1.csv') # Inspecting the 'CPI' column print(df['Weekly_Sales'].sample(5))
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 2. Capitolo 1
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Suggested prompts:
Mi faccia domande su questo argomento
Riassuma questo capitolo
Mostri esempi dal mondo reale
Awesome!
Completion rate improved to 3.45
Analyzing Columns
Scorri per mostrare il menu
Let's inspect how many object
columns are left.
12345678# 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_data2.csv') # Checking columns types print(df.dtypes)
As you can see, only 2 object
columns remain. So, what's wrong with the 'Weekly_Sales'
column?
12345678# 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_data1.csv') # Inspecting the 'CPI' column print(df['Weekly_Sales'].sample(5))
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 2. Capitolo 1