如何向資料框添加列xFlattened？在我的情況下xFlattened.columns沒有幫助我。
def corrFilter(x, bound):
xCorr = x.corr()
xFiltered = xCorr[((xCorr >= bound) | (xCorr <= -bound)) & (xCorr !=1.000)]
xFlattened = xFiltered.unstack().sort_values(ascending = False).drop_duplicates()
xFlattened.columns = ["first_value", "second_value", "corr"]
return xFlattened
d = {'review_scores_accuracy': [1.1, 2.0, 4.5, 5.0, 4.9, 4.8, 4.7],
'review_scores_rating': [1.1, 2.0, 4.6, 3.9, 4.2, 4.5, 4.2]}
df = pd.DataFrame(data=d)
df = corrFilter(df, .7)
df
我想要的是
first_value second_value percentage
0 review_scores_accuracy review_scores_rating 0.968217
1 review_scores_accuracy NaN
uj5u.com熱心網友回復：
您需要添加reset_index函式以將系列轉換為 DataFrame：
xFlattened = xFiltered.unstack().sort_values(ascending = False).drop_duplicates().reset_index()
輸出：
first_value second_value corr
0 review_scores_accuracy review_scores_rating 0.968217
1 review_scores_accuracy review_scores_accuracy NaN
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/360260.html