在数据帧列表中循环循环时，与TypeError的问题

Question

我有一个数据帧dataframes名称keeplist和dict hydrocap的列表。

我正在尝试基于列名keeplist在应用列循环中的where函数以将列中的值替换为字典中的列函数时（为其字典值替换为字典值（为其），相应的键）如果它大于字典值。问题是我遇到了typeError：'＆gt; ='在“ str”和'int'的实例之间不支持我不确定如何解决问题。

keeplist = ['BOUND','GCOUL','CHIEF','ROCKY','WANAP','PRIRA','LGRAN','LMONU','ICEHA','MCNAR','DALLE']

HydroCap = {'BOUND':55000,'GCOUL':280000,'CHIEF':219000,'ROCKY':220000,'WANAP':161000,'PRIRA':162000,'LGRAN':130000,'LMONU':130000,'ICEHA':106000,'MCNAR':232000,'DALLE':375000}

for i in dataframes:
  for c in i[keeplist]:
    c = np.where(c >= HydroCap[c], HydroCap[c], c)

任何朝着正确方向的推动都将不胜感激。我认为问题在于，它期望Hydrocap [1]而不是hydrocap [C]，但这是一个hunch。

dataFrame [0]的第一列列

      Week  Month  Day  Year         BOUND          GCOUL          CHIEF  \
0        1      8    5  1979  44999.896673  161241.036388  166497.578098   
1        2      8   12  1979  15309.259762   58219.122747   63413.204052   
2        3      8   19  1979  15316.965781   56072.024363   60606.956215   
3        4      8   26  1979  14371.269016   58574.003087   63311.569888 

Answer 1

import pandas as pd
import numpy as np

# Since I don't have all of the dataframes, I just use the sample you shared
df = pd.read_csv('dataframe.tsv', sep = "\t")

# Note, I've changed some values so you can see something actually happens
keeplist = ['BOUND','GCOUL','CHIEF']
HydroCap = {'BOUND':5500,'GCOUL':280000,'CHIEF':21900}

# The inside of the loop has been changed to accomplish the actual goal
# First, there are now two variables inside the loop: col, and c
# col is the column
# c represents a single element in that column at a time

# The code operates over a column at a time,
# using a list comprehension to cycle over each element
# and replace the full column with the new values at once
for col in df[keeplist]:
    df[col] = [np.where(c >= HydroCap[col], HydroCap[col], c) for c in df[col]]

生产的：

df

	周	月	每年	约束	5500.0	GCOUL	酋长
0	1	8	5	1979	21900.0	161241.036388	19
1	2	8	12	1979	5500.0	58219.122747	21900.0
2	2	3	8	要么	5500.0	您	1979
，	​	​	​	​	​	数据	​

框架 需要一次进行整列，或将值重新分配到由行和列坐标指定的单元格。在原始代码中重新分配c变量 - 我可以指示它表​​示您所考虑的单元格值，而不是像这种情况一样的列名，不会改变dataframe中的任何内容。