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.

# 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())

*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?

This hands-on course provides an opportunity to apply and consolidate your skills across a range of data analysis tasks using real-world dataset. You'll learn how to identify and address data issues, and then explore and visualize data using pandas, matplotlib, and seaborn to uncover insights and draw conclusions.

First, let's get acquainted with the data we will be working with. Throughout this section, we will perform the initial set of actions to prepare the data for further analysis.

In the second section, we will continue with the preparatory tasks started in the first section and ensure the data is ready for further exploration.

After preparing the data, we will move on to some exploratory analysis. Throughout this section, we will answer several questions and uncover interesting insights.

In the last section, we will use visualization tools to either confirm or reject the hypotheses we made in the previous section. We will also create visualizations of key indicators for the entire dataset.

Analyzing and Visualizing Real-World Data

How Periodic the Data is?