Data Wrangling with Sam Oranyeli

Data Wrangling with Python Datatable - Conditional Statements

Jan 18, 20214 min read

Transformation based on a Single Condition Source data Task: if c is positive, then value should be a - b, else b - a. from datatable import dt, f,...

Data Wrangling with Python Datatable - Row-wise Transformations

Jan 8, 20213 min read

Link to Source data datatable docs Task: Get the difference between the maximum and minimum values per row for Value columns. from datatable import...

Data Wrangling with Python Datatable - Transformations Within a GroupBy

Jan 7, 20212 min read

Link to Source data Task: Group data by Date and Zip and get the ratio of Price to maximum Price per group. from datatable import dt, f, update,...

Data Wrangling with Python Datatable - Select Columns by Data Type

Jan 6, 20212 min read

Link to Source data Datatable docs ltype stypes from datatable import dt, f df = dt.Frame({'a': [1, 2, 1, 2, 1, 2], 'b': [True, False,...

Data Wrangling with Python Datatable - Replicate Pandas' Map Function

Jan 4, 20213 min read

Link to Source data Task: Create a new column by mapping the values in the city column to the city_state dictionary from datatable import dt,...

Data Wrangling with python Datatable: Aggregate columns into new columns based on prefix

Jan 3, 20212 min read

Source Data Datatable docs # import libraries from collections import defaultdict from datatable import dt, f df = dt.Frame({'sn': [1, 2, 3], ...