Let's take a look at the intermediate results.

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

# Checking columns types
print(df.dtypes)

So far, there are three columns left that have an `object` data type. Let's examine the `'CPI'` column by displaying five random 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_data1.csv')

# Inspecting the 'CPI' column
print(df['CPI'].sample(5))

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-Life Data

Analyzing Columns [2/4]

What is wrong with the `'CDI'` column?