text_plain_output_1.png
import pandas as pd

earning = pd.read_csv('/kaggle/input/cusersmarildownloadsearningcsv/earning.csv', delimiter=';')
data = earning[['year', 'femalesmanagers', 'malemanagers', 'personmanagers', 'femalemachineryoperatorsanddrivers', 'malemachineryoperatorsanddrivers', 'personmachineryoperatorsanddrivers', 'femalesalesworkers', 'malesalesworkers', 'personsalesworkers']]
data.columns = ['year', 'manager_f', 'manager_m', 'manager_tot', 'operator_f', 'operator_m', 'operator_tot', 'sales_f', 'sales_m', 'sales_tot']
data

new_data = pd.DataFrame({'year': data['year'], 'manager': data['manager_m'] - data['manager_f'], 'operator': data['operator_m'] - data['operator_f'], 'sales': data['sales_m'] - data['sales_f']})
new_data.index = new_data['year']
new_data = new_data.drop('year', axis=1)
new_data

for beruf in new_data.columns:
    print(beruf)