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))
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 1
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 3.45
Analyzing Columns
Swipe to show 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))
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 1