Python sample code for cross table creation

To create cross table for given datam set in python.

Import libraries.

Read input file.

Defining the input variable.

Two way cross tab.

Three way cross tab.

#import libraries

import pandas as pd

data=pd.read_excel(‘/home/soft27/soft27

/Sathish/Pythonfiles/Employee.xlsx’)

print(“Actual data is\n”,data)

#create data frame

df=pd.DataFrame(data)

print(“Two way cross tab\n”)

#two way cross tab

a=pd.crosstab(df.salary, df.dept,margins=True)

print(a)

print(“Three way cross tab\n”)

#three way cross tab

b=pd.crosstab([df.dept, df.age],df.salary, margins=True)

print(b)

List

S-Logix (OPC) Private Limited