Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn That's All? | Preprocessing Data: Part II
Analyzing and Visualizing Real-World Data
course content

Course Content

Analyzing and Visualizing Real-World Data

Analyzing and Visualizing Real-World Data

1. Preprocessing Data: Part I
Loading the DataData TypesColumns OverviewRemoving Characters: Method 1Removing Characters: Method 2Checking ColumnsReplacing Characters
2. Preprocessing Data: Part II
Analyzing ColumnsRemoving and ReplacingProcessing DatesWrong Convertation?Proper ConvertingThat's All?
3. Analyzing Data
Superficial AnalysisThe Most Profitable StoreDate RangeHow Periodic the Data is?The Most Profitable PeriodsThe Best CombinationHolidays EffectWhat Holidays are we Considering?The Most Profitable Holiday
4. Visualizing Data
First Look at the DataComparing DynamicsFinding RelationDoes Temperature Affect?Or is it Holiday Effect?Comparing ShopsAdding Holidays to Comparison

book
That's All?

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)
copy

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

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 6

Ask AI

expand
ChatGPT

Ask anything or try one of the suggested questions to begin our chat

course content

Course Content

Analyzing and Visualizing Real-World Data

Analyzing and Visualizing Real-World Data

1. Preprocessing Data: Part I
Loading the DataData TypesColumns OverviewRemoving Characters: Method 1Removing Characters: Method 2Checking ColumnsReplacing Characters
2. Preprocessing Data: Part II
Analyzing ColumnsRemoving and ReplacingProcessing DatesWrong Convertation?Proper ConvertingThat's All?
3. Analyzing Data
Superficial AnalysisThe Most Profitable StoreDate RangeHow Periodic the Data is?The Most Profitable PeriodsThe Best CombinationHolidays EffectWhat Holidays are we Considering?The Most Profitable Holiday
4. Visualizing Data
First Look at the DataComparing DynamicsFinding RelationDoes Temperature Affect?Or is it Holiday Effect?Comparing ShopsAdding Holidays to Comparison

book
That's All?

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)
copy

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

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 6
We're sorry to hear that something went wrong. What happened?
some-alt