Skip to content

Instantly share code, notes, and snippets.

@mepsrajput

mepsrajput/proc_freq_with_missing.py

Created April 14, 2022 16:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mepsrajput/f7af2dc00eb8e0b2b30c354f193a8cfb to your computer and use it in GitHub Desktop.
Save mepsrajput/f7af2dc00eb8e0b2b30c354f193a8cfb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
proc_freq_with_missing.py
datax = data['GENRE'].value_counts(dropna=False)
datay = pd.DataFrame({
'GENRE': datax.index,
'Frequency': datax.values,
'Percent': ((datax.values/datax.values.sum())*100).round(2),
'Cumulative Frequency': datax.values.cumsum(),
'Cumulative Percent': ((datax.values.cumsum()/datax.values.sum())*100).round(2)
})
datay
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment