Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Leer How Periodic the Data is? | Analyzing Data
Analyzing and Visualizing Real-World Data
course content

Cursusinhoud

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
How 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.

question mark

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

Select the correct answer

Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 3. Hoofdstuk 4
Onze excuses dat er iets mis is gegaan. Wat is er gebeurd?
some-alt