As it says in the error, try using .loc[row_indexer,col_indexer]
to create the new column.
netc.loc[:,"DeltaAMPP"] = netc.LOAD_AM - netc.VPP12_AM.
Notes
By the Pandas Indexing Docs your code should work.
netc["DeltaAMPP"] = netc.LOAD_AM - netc.VPP12_AM
gets translated to
netc.__setitem__('DeltaAMPP', netc.LOAD_AM - netc.VPP12_AM)
Which should have predictable behaviour. The SettingWithCopyWarning
is only there to warn users of unexpected behaviour during chained assignment (which is not what you're doing). However, as mentioned in the docs,
Sometimes a SettingWithCopy
warning will arise at times when there’s no obvious chained indexing going on. These are the bugs that SettingWithCopy
is designed to catch! Pandas is probably trying to warn you that you’ve done this:
The docs then go on to give an example of when one might get that error even when it's not expected. So I can't tell why that's happening without more context.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…