如何在多页眉/多索引 pandas 数据框中设置单元格值 [英] How to set a cell value in a multi header/multi index pandas Dataframe

问题描述

我有一个看起来像这样的数据框:

I have a Dataframe that looks like that:

             SPY                                          
            Open        High         Low       Close      
             Bid   Ask   Bid   Ask   Bid   Ask   Bid   Ask
Date                                                      
2010-01-01   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN
2010-01-02   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN
2010-01-03   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN
2010-01-04   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN

我想设置一个特定的单元格值，例如日期为2010-01-04的公开出价，因此我尝试了以下操作:

I want to set a specific cell value, for example open bid for date 2010-01-04 so I tried this:

df.ix['2010-01-04', 'SPY']['Open']['Bid'] = 10

，但数据框未发生任何变化.当我在出价和要价更改的最终值中删除['Bid']时，但我不知道如何一次仅更改一个值.

but nothing has happened to the dataframe. When I remove ['Bid'] at the end values for both bid and ask change but I don't know how to change only one value at a time.

推荐答案

• 使用tuple获取MultiIndex元素
• .ix已被弃用.在这种情况下，请使用.at. .loc也可以，但是如果到达特定的单元格，则.at效率更高.
• Use a tuple to get at the MultiIndex element
• .ix has been deprecated. In this case, use .at. .loc would also work, but .at is more efficient if getting at a particular cell.

df.at['2010-01-04', ('SPY', 'Open', 'Bid')] = 10

这篇关于如何在多页眉/多索引 pandas 数据框中设置单元格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！