Зміст курсу

Data Preprocessing

1. Brief Introduction

Data Types Data Processing Methods Dataset: Test and Training Deleting an "Extra" Data Changing the Data Type

2. Processing Quantitative Data

Data Scaling Data Scaling vs Data Normalization Removing Outliers Removing Missing Values Data Augmentation: Synthetic Data

3. Processing Categorical Data

Methods for Encoding the Categorical Data One-Hot Encoding Ordinal Encoding Label Encoding of the Target Variable Challenge

4. Time Series Data Processing

Data Type Conversion Data Cleaning Stationarity Denoising Train/Test Split & Cross Validation Challenge

5. Feature Engineering

Technique Idea Realization Feature Extraction from Text Feature Extraction from Images Feature Extraction from Time Series Challenge

6. Moving on to Tasks

Challenge 1 Challenge 2 Challenge 3

Changing the Data Type

You already know how to change the data type from string to number, for example. But let's take a closer look at this small but important task.

Let's start by changing the data type from string to datetime. Most often, you will need this to work with time series. You can perform this operation using the .to_datetime() method:

To convert a string to a bool - use the .map() method on the column whose values you want to change:

For example, if you have a price column that looks like "$198,800" and you want to turn it into a float - you should create custom transformation functions:


              12345678910111213
            
import pandas as pd
import re

# Create simple dataset
df = pd.DataFrame(data={'Price':['$4,122.94', '$1,002.3']})

# Create a custom function to transform data
# x - value from column
def price2int(x):
  return float(re.sub(r'[\$\,]', '', x))

# Use custom transformation on a column
df['Price'] = df['Price'].apply(price2int)

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 1. Розділ 5

Changing the Data Type

You already know how to change the data type from string to number, for example. But let's take a closer look at this small but important task.

Let's start by changing the data type from string to datetime. Most often, you will need this to work with time series. You can perform this operation using the .to_datetime() method:

To convert a string to a bool - use the .map() method on the column whose values you want to change:

For example, if you have a price column that looks like "$198,800" and you want to turn it into a float - you should create custom transformation functions:


              12345678910111213
            
import pandas as pd
import re

# Create simple dataset
df = pd.DataFrame(data={'Price':['$4,122.94', '$1,002.3']})

# Create a custom function to transform data
# x - value from column
def price2int(x):
  return float(re.sub(r'[\$\,]', '', x))

# Use custom transformation on a column
df['Price'] = df['Price'].apply(price2int)

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Все було зрозуміло?

Секція 1. Розділ 5

Changing the Data Type

You already know how to change the data type from string to number, for example. But let's take a closer look at this small but important task.

Let's start by changing the data type from string to datetime. Most often, you will need this to work with time series. You can perform this operation using the .to_datetime() method:

To convert a string to a bool - use the .map() method on the column whose values you want to change:

For example, if you have a price column that looks like "$198,800" and you want to turn it into a float - you should create custom transformation functions:


              12345678910111213
            
import pandas as pd
import re

# Create simple dataset
df = pd.DataFrame(data={'Price':['$4,122.94', '$1,002.3']})

# Create a custom function to transform data
# x - value from column
def price2int(x):
  return float(re.sub(r'[\$\,]', '', x))

# Use custom transformation on a column
df['Price'] = df['Price'].apply(price2int)

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Все було зрозуміло?

You already know how to change the data type from string to number, for example. But let's take a closer look at this small but important task.

Let's start by changing the data type from string to datetime. Most often, you will need this to work with time series. You can perform this operation using the .to_datetime() method:

To convert a string to a bool - use the .map() method on the column whose values you want to change:

For example, if you have a price column that looks like "$198,800" and you want to turn it into a float - you should create custom transformation functions:


              12345678910111213
            
import pandas as pd
import re

# Create simple dataset
df = pd.DataFrame(data={'Price':['$4,122.94', '$1,002.3']})

# Create a custom function to transform data
# x - value from column
def price2int(x):
  return float(re.sub(r'[\$\,]', '', x))

# Use custom transformation on a column
df['Price'] = df['Price'].apply(price2int)

Завдання

Read the sales_data_types.csv dataset and change the data type in the Active column from str to bool.

Секція 1. Розділ 5