I need to import data from a CSV file to python. Then calculate total customer_value per "last_city".
Here is my code:
import pandas as pd
customer = pd.read_csv('D:\PythonTraining\Customer.csv')
df2 = customer.groupby('Last_city').sum('Customer_Value')
print(df2)
Why does python return the customer_value in this wired format? How could I change it? FYI the Customer_Value data type is float64.