PDS001 – Select Audit Samples Using KNIME

Practical Data Science Demo 001 Solution

Select Audit Samples Using KNIME


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()


Leave a Reply

Your email address will not be published.