我有两个pandas数据帧-weight
在Land Use
列上有一个简单的索引。concentration
在Land Use
和Parameter
上有一个多重索引。在
import pandas
from io import StringIO
conc_string = StringIO("""\
Land Use,Parameter,1E,1N,1S,2
Airfield,BOD5 (mg/l),0.418,0.118,0.226,1.063
Airfield,Ortho P (mg/l),0.002,0.001,0.001,0.002
Airfield,TSS (mg/l),1.773,11.47,0.862,0.183
Airfield,Zn (mg/l),0.001,0.001,4.95E-05,0.001
"Commercial",BOD5 (mg/l),0.036,0.0419,,0.315
"Commercial",Cu (mg/l),4.37E-05,7.34E-05,,0.00039
"Commercial",O&G (mg/l),0.0385,0.127,,0.263
Open Space,TSS (mg/l),0.371,3.01,1.209,0.147
Open Space,Zn (mg/l),0.0127,0.0069,0.0132,0.007
"Parking Lot",BOD5 (mg/l),0.924,0.0668,2.603,3.19
"Parking Lot",O&G (mg/l),1.02,0.149,1.347,1.88
"Rooftops",BOD5 (mg/l),0.135,1.00,0.0562,0.310""")
weight_string = StringIO("""\
Land Use,1E,1N,1S,2
Airfield,0.511,0.0227,0.0616,0.394
Commercial,0.0005,0.1704,0,0.1065
Open Space,0.0008,0.005,0.0002,0.0004
"Parking Lot",0.33,0.514,0.252,0.171
Rooftops,0.081,0.028,8.50E-05,0.003""")
concentration = pandas.read_csv(conc_string, index_col=[0,1])
weight = pandas.read_csv(weight_string, index_col=0)
在这种情况下,列(1E、1N、1S和2)是流域。在
我想做的是将所有与Parameter
无关的浓度除以其中的盆(列名)和Land Use
的权重。在
我在这里运气不好。concentration / weight
当然不起作用。我没有太多的运气堆叠数据帧和加入
当我停止on
kwarg时,最后两行不会引发错误,而是返回连接列的NaN
结果。如果我删除两个堆叠数据帧的索引(例如,在连接之前做wstk.reset_index(inplace=True)
),它们也会失败。在
有什么建议吗?在
{and want broadcast}for the multi-matching}方法在索引中使用{
来自
div
的文档:相关问题 更多 >
编程相关推荐