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
Import Columns from Excel as Dates Using Pandas
Python
Import and Export
To import certain columns as dates from an Excel sheet using Pandas, simply use the "parse_dates" parameter to pass a list of columns that should be imported as dates.
1| import pandas as pd 2| 3| df = pd.read_excel('Returns.xlsx', 4| sheet_name='Returns', 5| parse_dates=['order_date'])
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