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

Posts

• Filtering Rows in Datatable

  Explore various ways of filtering in python Datatable.

  Nov 4, 2022

• Dplyr's across: Replicating within Pandas

  Columnwise operations in Pandas - as simply as possible

  Sep 30, 2022

• Fast and Efficient Inequality Joins in Pandas

  Compute inequality joins better than a cross join or a naive nested loop.

  Sep 30, 2022

• Pivot_longer : Reshape Data in Pandas Efficiently and with Ease from Wide to Long

  Reshaping Data Efficiently and with Ease

  Sep 8, 2022

• Data Wrangling with Python Datatable - Selecting Columns

  Various Ways to select Columns

  Feb 9, 2021

• Data Wrangling with Python Datatable - Conditional Statements

  Transformations based on conditions

  Jan 18, 2021

• Data Wrangling with Python Datatable - Row-wise Transformations

  Transformations per row

  Jan 8, 2021

• Data Wrangling with Python Datatable - Transformations Within a GroupBy

  Transformations per Group

  Jan 7, 2021

• Data Wrangling with Python Datatable - Select Columns by Data Type

  Column Selection

  Jan 6, 2021

• Data Wrangling with Python Datatable - Replicate Pandas' Map Function

  Replace values in a column with a dictionary

  Jan 4, 2021

• Data Wrangling - Aggregation on Multiple Columns

  Create new columns by aggregation

  Jan 3, 2021

• Easy Web Scraping with Python

  And build a data application

  Dec 18, 2020

• Read Multiple CSV Files into one Frame in Python

  Explore in Pandas and Python datatable

  Nov 5, 2020

• Replicating .SD in Python Datatable

  Work with Subset of Data

  Aug 13, 2020

• Extract DataFrame from Compressed Data into Python Datatable

  Extract tables from compressed data with ease

  Jul 28, 2020