import pandas as pd

# Load the CSV file into a DataFrame
df = pd.read_csv('/mnt/data/Wuppertal-Vornamen_2012.csv')

# Display the first few rows of the DataFrame
df.head()

  vorname;anzahl;geschlecht
0               Sophie;52;w
1                Marie;51;w
2           Maximilian;35;m
3                 Luca;27;m
4            Alexander;26;m

# Load the CSV file into a DataFrame with the correct delimiter
df = pd.read_csv('/mnt/data/Wuppertal-Vornamen_2012.csv', delimiter=';')

# Display the first few rows of the DataFrame
df.head()

      vorname  anzahl geschlecht
0      Sophie      52          w
1       Marie      51          w
2  Maximilian      35          m
3        Luca      27          m
4   Alexander      26          m

# Get some general info about the DataFrame
df_info = df.describe(include='all')

# Count the number of unique names for each gender
unique_names_gender = df.groupby('geschlecht')['vorname'].nunique()

# Get the most common names
common_names = df.nlargest(5, 'anzahl')

df_info, unique_names_gender, common_names

(       vorname       anzahl geschlecht
 count     1816  1816.000000       1816
 unique    1805          NaN          2
 top     Sophie          NaN          m
 freq         2          NaN        923
 mean       NaN     2.012115        NaN
 std        NaN     3.049431        NaN
 min        NaN     1.000000        NaN
 25%        NaN     1.000000        NaN
 50%        NaN     1.000000        NaN
 75%        NaN     2.000000        NaN
 max        NaN    52.000000        NaN,
 geschlecht
 m    923
 w    893
 Name: vorname, dtype: int64,
       vorname  anzahl geschlecht
 0      Sophie      52          w
 1       Marie      51          w
 2  Maximilian      35          m
 3        Luca      27          m
 4   Alexander      26          m)

An experimental model that can solve tasks by generating Python code and executing it in a Jupyter notebook.
You can upload any kind of file, and ask model to analyse it, or produce a new file which you can download.

Analyse der Vornamen 2012