# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python [conda env:PythonData] *
#     language: python
#     name: conda-env-PythonData-py
# ---

import pandas as pd

csv_file = "Analysis/CategoryCountsPerCountry.csv"
freq_df = pd.read_csv(csv_file, encoding="utf-8")
freq_df

freq_df.set_index('CategoryID', inplace=True)
freq_df

frequency_df = freq_df.transpose()
frequency_df

frequency_df.to_csv('Analysis/freq_transpose.csv')

StarcoderdataJupyterScriptsDedupFiltered