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
Selecting Columns to Import from Excel Using Pandas
Python
Import and Export
To select which columns to import from an Excel sheet into a Pandas dataframe, simply pass a list of the required columns to the "usecols" parameter of read_excel.
In the example below we only want to import the "OrderNo" and "ProductID" columns from the Returns sheet.
1| import pandas pd 2| 3| df = pd.read_excel('Returns.xlsx', 4| sheet_name='Returns', 5| usecols=['OrderNo','ProductID'])
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