Pythonデータフレームは2つの列を分割します

Python Dataframe Divide Two Columns

対応する列を直接分割するか、適用機能を使用します

import pandas as pd df = pd.read_csv('Offline data.csv') #Create a Dataframe df_data = pd.DataFrame(columns=['total','Number','average value']) df_data[['total','Number']] = df #1, use the apply function df_data['average value'] =df_data.apply(lambda x: x['total'] / x['Number'], axis=1) #2, direct division df_data['average value'] = df_data['total'] /df_data['Number'] #Export data, add encoding='utf_8_sig' to avoid Chinese garbled characters when importing to csv file and opening with excel df_data.to_csv('Average calculation.csv', sep=',', header=True, index=True,encoding='utf_8_sig')