Search for a command to run...
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], "...
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...
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...
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 ...
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"], ...
Source Data Datatable docs # import libraries from collections import defaultdict from datatable import dt, f df = dt.Frame({'sn': [1, 2, 3], 'C1-1': [4, 2, 1], 'C1-2': [3, 2, 2], 'C1-3': [5, 0, 0], ...
Access Excel Tables with Python This post is about extracting data from Excel tables into Python. Source data is with permission from ExcelisFun You can try your hands with the accompanying notebook Excel Tables are a great way of grouping related ...
Link to Source data Link to Notebook Pandas Via read_csv import pandas as pd from pathlib import Path # create a Path instance and filter for only csv files files = Path("./Data_files/multiple_csvs/").rglob("*.csv") # read in all the csv files all_...
.SD - Subset of Data I will be using Jose Morales excellent post to show how .SD's functionality can be replicated in python's datatable. Not all functions can be replicated; R data.table has a whole lot more functions and features that are not yet ...