Python Forum
pandas: Compute the % of the unique values in a column
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pandas: Compute the % of the unique values in a column
#1
Hi

I am new to crosstab & pivot tables.


DF


|   |  Firm |
0  |  A      | 
1  |  A      | 
2  |  B      | 
3  |  B      | 

Desired Outcome



A | 0.5
B |  0.5
Tried the below but get
TypeError: crosstab() missing 1 required positional argument: 'columns'

ct_df = pd.crosstab(df['Firm'], normalize=True, margins=True, dropna=False)
Reply
#2
For that would use groupby, not crosstab.

import pandas as pd
df = pd.DataFrame([[1,'A'],[2,'A'],[3,'B'],[4,'B']], columns=['Numbers','Letters'])
idx = df.index
nrows = len(idx)
df1 = df.groupby(by='Letters').size()/nrows
df1
Output:
Letters A 0.5 B 0.5 dtype: float64
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Assigning conditional values in Pandas Scott 3 700 Dec-19-2023, 03:10 AM
Last Post: Larz60+
  HTML Decoder pandas dataframe column mbrown009 3 931 Sep-29-2023, 05:56 PM
Last Post: deanhystad
  attempt to split values from within a dataframe column mbrown009 8 2,189 Apr-10-2023, 02:06 AM
Last Post: mbrown009
  Make unique id in vectorized way based on text data column with similarity scoring ill8 0 855 Dec-12-2022, 03:22 AM
Last Post: ill8
  Increase df column values decimals SriRajesh 2 1,074 Nov-14-2022, 05:20 PM
Last Post: deanhystad
  pandas column percentile nuncio 7 2,357 Aug-10-2022, 04:41 AM
Last Post: nuncio
  how to expand each unique value in another column and fill zero if no match SriRajesh 0 803 Jul-10-2022, 09:21 AM
Last Post: SriRajesh
  Separating unique, stable, samples using pandas keithpfio 1 1,053 Jun-20-2022, 07:06 PM
Last Post: keithpfio
  update values in one dataframe based on another dataframe - Pandas iliasb 2 9,036 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  Pandas Data frame column condition check based on length of the value aditi06 1 2,635 Jul-28-2021, 11:08 AM
Last Post: jefsummers

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020