Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.How Periodic the Data is? | Analyzing Data
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

bookHow Periodic the Data is?

Okay, now we know that the dataset contains about 2 years of data. But how periodic is the data? Do we have daily or less periodic data? Let's find out by inspecting several consecutive values.


              
123456789

            
# 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')
df['Date'] = pd.to_datetime(df['Date'], dayfirst = True)

# Inspecting the first 5 records of the 'Date' column
print(df['Date'].head())
copy

For the following question, feel free to edit the code above, if needed.

What is the frequency or periodicity of the data we are analyzing?

What is the frequency or periodicity of the data we are analyzing?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 4
some-alt