Question

How to make a table from a csv file without using prettytable or pandas. I have to use format I'm trying to...

I'm trying to get a column for "Type", "Total", and "Percent" from TipJoke.csv file.

import csv
with open('TipJoke.csv', newline='') as csv_file:
filereader = csv.reader(csv_file, delimiter=' ')
for row in filereader:
print( '{:2} {:3} {:4}'.format('Type', 'Total', 'Percent'))
print(', '.join(row))

Answer 1

CODE:

import pandas as pd

df=pd.read_csv('data/My_Data/Chegg/TipJoke.csv')#Loading the csv file into dataframe

print(df.head())#Viewing the basic format of dataframe or the file

total_items=len(df) #To get the total items for calculating percentage

df['Card'].value_counts()#It gives us the count of each item in card

items=[]for type in df['Card'].unique():

total=df['Card'].value_counts().loc[type]#Getting the count of each items

percent=total/total_items#Calculating the percentage and below we are formating as given

type='{:2}'.format(type)

total='{:3}'.format(total)

percent='{:4}'.format(percent)

items.append([type,total,percent])

table=pd.DataFrame(items,columns=['Type','Total','Percent'])#Creating DataFrame to form table with given data and columns

print(table)#Priniting the table

OUTPUT: