对于混合位置和索引,请使用
.ix。但是您需要确保索引不是整数,否则会引起混乱。
df.ix[0, 'COL_NAME'] = x
更新:
或者,尝试
df.iloc[0, df.columns.get_loc('COL_NAME')] = x例:
import pandas as pdimport numpy as np# your data# ========================np.random.seed(0)df = pd.Dataframe(np.random.randn(10, 2), columns=['col1', 'col2'], index=np.random.randint(1,100,10)).sort_index()print(df) col1 col210 1.7641 0.400224 0.1440 1.454329 0.3131 -0.854132 0.9501 -0.151433 1.8676 -0.977336 0.7610 0.121756 1.4941 -0.205258 0.9787 2.240975 -0.1032 0.410676 0.4439 0.3337# .iloc with get_loc# ===================================df.iloc[0, df.columns.get_loc('col2')] = 100df col1 col210 1.7641 100.000024 0.1440 1.454329 0.3131 -0.854132 0.9501 -0.151433 1.8676 -0.977336 0.7610 0.121756 1.4941 -0.205258 0.9787 2.240975 -0.1032 0.410676 0.4439 0.3337


