# Trying to find Total Sales & Total Cost of 3 different Countries cars

## Trying to find Total Sales & Total Cost of 3 different Countries cars

Contents

Problem Description:

Update: Below is the excel file link.

I am brand new to Python and was doing this graph but I am stuck, I am trying to show a horizontal bar graph with 3 different countries, spain, germany, switzerland and trying to show the the total sales and total costs. I keep getting an error but not sure If my formula is correct If you could please take a look.

Error I get is below. If someone could please assist!

line 33
total.plot(‘CountryMake’, [‘Total Sales Price’, ‘Total Cost Price’], kind=’barh’)
^
SyntaxError: invalid syntax

``````import pandas as pd

spa= sales[sales['CountryName'] == 'Spain']

spa_totals = spa.sum(axis=0, numeric_only = True)
spa_count = spa.count(axis=0)

spa_total_sale_price = round(spa_totals) ['SalePrice']
spa_total_cost_price = round(spa_totals) ['CostPrice']

swi= sales[sales['CountryName'] == 'Switzerland']

swi_totals = spa.sum(axis=0, numeric_only = True)
swi_count = spa.count(axis=0)

swi_total_sale_price = round(swi_totals) ['SalePrice']
swi_total_cost_price = round(swi_totals) ['CostPrice']

ger= sales[sales['CountryName'] == 'Germany']

ger_totals = ger.sum(axis=0, numeric_only = True)
ger_count = ger.count(axis=0)

ger_total_sale_price = round(ger_totals) ['SalePrice']
ger_total_cost_price = round(ger_totals) ['CostPrice']

totals = pd.DataFrame([('Spain',spa_tot_sale_price, spa_tot_cost_price),
('Switzerland', swi_tot_sale_price,swi_tot_cost_price),
('Germany', ger_tot_sale_price,ger_tot_cost_price),
columns ['CountryName', 'Total Sales Price', 'Total Cost Price']
total.plot('CountryMake', ['Total Sales Price', 'Total Cost Price'], kind='barh')

Error I get is below. If someone could please assist!

File "C:UsersdanacAppDataLocalTempipykernel_166162535154149.py", line 33
total.plot('CountryMake', ['Total Sales Price', 'Total Cost Price'], kind='barh')
^
SyntaxError: invalid syntax

``````

## Solution – 1

I don’t think that you defined `total` in this part of the code. So, you may need to do `totals.plot`. You also didn’t close the brackets.

``````import pandas as pd
import matplotlib.pyplot as plt

spa= sales[sales['CountryName'] == 'Spain']

spa_totals = spa.sum(axis=0, numeric_only = True)
spa_count = spa.count(axis=0)

spa_total_sale_price = round(spa_totals) ['SalePrice']
spa_total_cost_price = round(spa_totals) ['CostPrice']

swi= sales[sales['CountryName'] == 'Switzerland']

swi_totals = spa.sum(axis=0, numeric_only = True)
swi_count = spa.count(axis=0)

swi_total_sale_price = round(swi_totals) ['SalePrice']
swi_total_cost_price = round(swi_totals) ['CostPrice']

ger= sales[sales['CountryName'] == 'Germany']

ger_totals = ger.sum(axis=0, numeric_only = True)
ger_count = ger.count(axis=0)

ger_total_sale_price = round(ger_totals) ['SalePrice']
ger_total_cost_price = round(ger_totals) ['CostPrice']

totals = pd.DataFrame([('Spain',spa_total_sale_price, spa_total_cost_price),
('Switzerland', swi_total_sale_price,swi_total_cost_price),
('Germany', ger_total_sale_price,ger_total_cost_price)],
columns=['CountryName', 'Total Sales Price', 'Total Cost Price'])
totals.plot('CountryName', ['Total Sales Price', 'Total Cost Price'], kind='barh')
plt.show()
``````

This should work, although I don’t guarantee given that I don’t have your data.
P.S.
Try to use IDEs. It will be easier that way

Rate this post
We use cookies in order to give you the best possible experience on our website. By continuing to use this site, you agree to our use of cookies.