I am trying to get a simpler method to obtain summary of values against each type in a dataframe

Asked Aug 03 '20 at 15:08

Active Aug 03 '20 at 15:09

Viewed 25 times

I have a dataframe which contains 7800 rows and 2 columns. The columns are loan type and outstanding value. I am looking to print a dataframe which will provide me the loan types and the outstanding.

Loan_Type   Outstanding_Value
Home Loan   $500000
Auto Loan   $3000 
Home loan   $300000
Over Draft  $10000
Home Loan   $100000

I tried using,

result=df['Loan_Type'].unique(),df['Outstanding_Value'].sum()

edited Aug 03 '20 at 15:09

ALollz

57,915
7
66
89

asked Aug 03 '20 at 15:08

Harry Smith

4

`df.groupby('Loan_Type').sum()`? – Quang Hoang Aug 03 '20 at 15:10
nope.. it did not work.gives me TypeError: 'method' object is not subscriptable – Harry Smith Aug 03 '20 at 15:31
1

@HarrySmith It will work, you just made a mistake. Based on that error you probably accidentally used `[]` instead of `()`. There are parentheses to specify the group keys: df.groupby **(** 'Loan_Type' **)**, not brackets. – ALollz Aug 03 '20 at 15:45
1

Thanks, @ALollz it's my bad got the brackets incorrect – Harry Smith Aug 03 '20 at 16:14
@ALollz, is there a way to do this with original dataframe without dropping "NA" values under ('Loan_Type')? – Harry Smith Aug 03 '20 at 17:00

I am trying to get a simpler method to obtain summary of values against each type in a dataframe

0 Answers0