修改csv文件的数据-python

当使用x.loc[row][‘column_name’]来访问和修改DataFrame的数据时，必须使用at或iat方法才能正确地进行赋值操作。

import pandas as pd

x = pd.read_csv('data.csv')
rows = x.shape[0]

for row in range(rows):
    x.at[row, 'column_name'] = 4011.072726743443 * x.at[row, 'column_name'] ** 0.1 - 7174.897043023494
    
    x.at[row, 'column_name1'] = 0.008438982741439761 * x.at[row, 'column_name1'] ** 2 - 1.5198687477542732 * x.at[row, 'column_name1'] + 116.30875308399733

x.to_csv('data.csv')