Data Preprocessing with Pandas
IMPORT DATA
CSV
EXCEL
SCRAPE DATA
PREPARE DATA
CONVERTING
CLEANING NANS
CLEANING STRINGS
SELECTING & RENAMING
SAMPLING
FILTERING
TRANSFORM
SUMMARISE
JOIN
MERGE
UNION
FEATURE ENGINEERING
WINDOW & LAG FEATURES
STRINGS
DATES
STATISTICS & FORMULAS
Read CSV - Selecting the Row that Contains Column Header
Python
Import and Export
To select which row to use as a header when reading a csv into a Pandas dataframe, use the "header" parameter to pass the row index of the row that contains the headers.
In the example below, we are using the values in the 3rd row for the headers of the dataframe.
1| import pandas as pd 2| 3| df = pd.read_csv('sales.csv', header=2)
2
Creating a Pandas DataFrame from a Python Generator
Python
Import and Export
2
2
2
Reading CSV Files from Amazon S3 into Pandas Dataframes
Python
Import and Export
1
Sklearn Iris Dataset - Load The Iris Dataset & Split Into Features & Target
Python
Import and Export
1
Using Selectors in Beautiful Soup to Scrape Using Classes & IDs
Python
Import and Export
1
1
1
Find the Nth Tag On a WebPage with Beautiful Soup
Python
Import and Export
1