我不是一个好的python程序员(初学者),所以如果代码不能满足pythonista的要求,我很抱歉!有点奇怪,我搞不懂。我一直在绞尽脑汁想解决这个问题,但似乎无法解决。我确信这是一个很简单的解决办法,我忽略了.
"allData“Dataframe正在从SQL数据库中提取数据。由此,我提取了许多记录,并附加到"managerListImput“空数据格式中。我正在迭代一些指定的记录,并在追加之前查找每个记录的详细信息。它在木星笔记中工作,我得到了想要的输出,但是当我在空闲或Visual代码中运行它时,就会得到一个空的dataframe。非常令人沮丧。希望有人能解决它..。提前感谢
下面是代码:
def selected():
managerReturns = pd.DataFrame(columns = ['hName','Returns'])
managerCount = int(input("how many MANAGERS do you want to use? Enter a quantity: "))
i=0
while i < managerCount:
managerListData = allData[['hID','hName','Min_Date','Max_Date']]
managerListFind = input('Enter partial or whole MANAGER name: ')
managerList = managerListData[managerListData['hName'].str.contains(managerListFind, case=False)]
managerList = managerList.drop_duplicates(subset=['hID'])
managerList = managerList.set_index('hID')
print(managerList)
managerID = input('Pick/Type in an MANAGER list ID ("hID") From the List Above: ')
managerName = managerListData.query('hID ==' + str(managerID))['hName']
managerName = managerName.iloc[0] # otherwise you get a list of the same names
manager = allData.query('hID == @managerID')
manager = manager.filter(['hName','Returns'])
managerReturns = managerReturns.append(manager)
i += 1
managerReturns = managerReturns.groupby([managerReturns.index, 'hName'])['Returns'].mean().unstack()
return managerReturns
test31 = selected()
print(test31)以空闲或代码输出:
Empty DataFrame
Columns: []
Index: []输出(以木星注释为单位),即我想要的输出!::
Date Manager1 Manager2
4/1/2010 NaN 0.1459
5/1/2010 NaN 0.0049
6/1/2010 NaN -0.0206
7/1/2010 NaN -0.0416
8/1/2010 NaN 0.4537
... ... ...
7/1/2021 0.0056 0.0047
8/1/2021 0.0185 -0.0086
9/1/2021 -0.0269 0.0207
10/1/2021 0.0261 -0.0080
11/1/2021 -0.0256 0.0228发布于 2021-12-03 18:55:14
解决方案很简单:必须将managerID转换为整数,因此我添加了以下内容:
managerID = int(managerID)我想朱庇特笔记是足够聪明的识别它作为一个数字。
https://stackoverflow.com/questions/70205677
复制相似问题