

# https://www.globalsino.com/ICs/page4853.html
# Sort data in a CSV file

import pandas as pd

My_Data = pd.read_csv('C:\GlobalSino\ICs\ExampleFiledUsedINtestingPython\CityDateB.csv', delimiter=',')
print(My_Data)

print('=================')
sum_LifeTime_column = My_Data['LifeTime'].sum()
sum_Weight_column = My_Data['Weight'].sum()

print (sum_LifeTime_column)
print(sum_Weight_column)

LifeTime_by_Region = My_Data.groupby('Region')['LifeTime'].sum()
percent_of_total = (LifeTime_by_Region/sum_LifeTime_column)*100

print('=================')

print(LifeTime_by_Region)
print('=================')
print(percent_of_total)

