Calculating a value based on another columns value

Asked Jan 23 '20 at 22:36

Active Jan 24 '20 at 01:07

Viewed 69 times

I have a CSV that has two columns: ['item', 'price]. I want to calculate the total price of each item separately. For example, let's say that the 'item' column has 4 rows with the value 'brown shoes'. I want to find the sum of 'price' when df['item'] is equal to 'brown shoes'.

I have tried this:

for i in df['item']:
        if i == 'brown shoes':
           df = df.loc['price'].sum()

Not sure why this isn't working. The error i'm getting is:

"Unalignable boolean Series provided as " pandas.core.indexing.IndexingError: Unalignable boolean Series provided as indexer (index of the boolean Series and of the indexed object do not match).

Is there something i'm missing?

asked Jan 23 '20 at 22:36

Jason000

2

Use `df.loc[df['item'] == "brown shoews", 'price'].sum()` – Scott Boston Jan 23 '20 at 22:39
4

I think you want `df.groupby('item')['price'].sum()` – Erfan Jan 23 '20 at 22:42
@Erfan can you vote to close when you get a mo? – Umar.H Jan 24 '20 at 00:19
Error aside, that’s an unidiomatic way of doing things. I urge you to read the pandas docs. – AMC Jan 24 '20 at 00:55

Calculating a value based on another columns value

0 Answers0