[Python] Python Pandas - trying to get counts and percentages for all fields - Can only get...

I want to import some survey data, loop through all fields, and run counts and percentages. I'm struggling to get this to work for both a count and percentage of each value in a question.

For example, here's what a survey question might look like:

Q1

ID Response
1 White
2 Black
3 Black

DESIRED OUTPUT:
Q1

Black 2 66.6%
White 1 33.3%


Below is my attempt and I know it isn't correct, but I want to show that I am trying.

import pandas as pd
import numpy as np
dataset = pd.read_excel('imp_survey_analyze.xlsx')

for column in df.columns
print("\n" + column)
print(df[column].value_counts())

Continue reading...