Skip to content

Instantly share code, notes, and snippets.

@mepsrajput
Last active April 14, 2022 14:29
Show Gist options
  • Save mepsrajput/25e474875464ca76100bcc29e610e01b to your computer and use it in GitHub Desktop.
Save mepsrajput/25e474875464ca76100bcc29e610e01b to your computer and use it in GitHub Desktop.
# Import Pandas
import pandas as pd
# Import CSV
data = pd.read_csv("../input/us-election-2020/governors_county.csv");
# Frequencies in Actual Order
datax = data['state'].value_counts().sort_index()
# Create a dataframe
datay = pd.DataFrame({
'state': 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)
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment