@Samukweku

Data Wrangling with Python Datatable - Conditional Statements

Jan 18, 2021 · 4 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, update, ifelse df = dt.Frame({"a": [1, 1, 2, 4], "b": [2, 2, 3, 2], "...

Data Wrangling with Python Datatable - Row-wise Transformations

Jan 8, 2021 · 3 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 dt, f, update df = dt.Frame({'Ind': [1, 2, 3], 'Department': ['Electronics', 'Clothing...

Data Wrangling with Python Datatable - Transformations Within a GroupBy

Jan 7, 2021 · 2 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, by df = dt.Frame( { "Date": ["2019-01-01", "2019-01-01", "2019-01-01", "20...

Data Wrangling with Python Datatable - Select Columns by Data Type

Jan 6, 2021 · 2 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, True, False, True, False], 'c': [1.0, 2.0, 1.0, 2.0, 1.0, 2.0]}) df | a ...

Data Wrangling with Python Datatable - Replicate Pandas' Map Function

Jan 4, 2021 · 3 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, f raw_data = {"first_name": ["Jason", "Molly", "Tina", "Jake", "Amy"], ...