PDS001 – Select Audit Samples Using KNIME

Practical Data Science Demo 001 Solution

Select Audit Samples Using KNIME

Scenario:

1. Select 30 samples for audit from the City Payroll Data.

2. Further refine your samples by selecting from “Police Officer I” only.

Data Source: https://www.kaggle.com/datasets/cityofLA/city-payroll-data?resource=download

Python Script:

import pandas as pd

sample_size = 30

input_table_2 = input_table_1.sample(sample_size)

# Copy input to output

output_table_1 = input_table_2.copy()

Solution: