Construct a Crosstable for the variables ‘dept’ and “salary” and find out which department has highest frequency value in the category low salary. For data science using Python in Anaconda - Jupyter

#import the library Pandas

import pandas as pd

#Put the People Charm case.csv dataset on Root Directory

#Read the dataset 

data = pd.read_csv('People Charm case.csv')

#Construct a Crosstable for the variables ‘dept’ and “salary”.

#find out which department has highest frequency value in the category low salary

pd.crosstab(index = data['dept'],columns = data['salary'])

Output:-