Skip to main content

Ctrl+K

Data Wrangling and Automation

Introduction

Working with Spreadsheets

Access Excel Tables with Python
SpreadSheet Munging Strategies in Python - Small Multiples
SpreadSheet Munging Strategies in Python - Meaningful Formats
SpreadSheet Munging Strategies in Python - Pivot Tables - Simple Unpivoting
SpreadSheet Munging Strategies in Python - Pivot Tables - Complex Unpivoting

Pydatatable

Replicating .SD in Python Datatable
Data Wrangling with Python Datatable - Conditional Statements
Data Wrangling with Python Datatable - Row-wise Transformations
Data Wrangling with Python Datatable - Select Columns by Data Type
Data Wrangling with Python Datatable - Replicate Pandas’ Map Function
Filtering Rows in Datatable
Selecting and Grouping Data with Python Datatable
Data Wrangling with Python Datatable - Selecting Columns
Extract DataFrame from Compressed Data into Python Datatable
Data Wrangling with Python Datatable - Transformations Within a GroupBy
Data Wrangling - Aggregation on Multiple Columns

CSVs

Read Multiple CSV Files into one Frame in Python

Pandas

Dplyr’s across: Replicating within Pandas
Fast and Efficient Inequality Joins in Pandas
Pivot_longer : Reshape Data in Pandas Efficiently and with Ease from Wide to Long
Extract DataFrame from Compressed Data into Pandas

Web Scraping

Easy Web Scraping with Python

Polars

Dplyr’s across: Replicating within Polars
Reshape Data in Polars Efficiently from Wide to Long Form - Part I
Reshape Data in Polars Efficiently from Wide to Long Form - Part II
Reshape Data in Polars Efficiently from Wide to Long Form - Part III

Repository
Open issue

.md

Introduction

Introduction#

Author: Samuel Oranyeli

2021-02-11

Welcome

This space is a collection of my thoughts/scripts related to data wrangling and automation.

next

Access Excel Tables with Python

By Samuel Oranyeli

© Copyright 2021.