代码是这样的:
import pandas as pd
df = pd.read_excel("abc.xlsx", sheet_name="sheet1")
df[['b','c']] = df[['b','c']].apply(lambda x: x*100)
df[['b','c']] = df[['b','c']].apply(lambda x: round(x, 1))
df[['b','c']] = df[['b','c']].astype(str) + '%'
我得到了想要的结果,因为:
a b c
0 Savings 0.8% 4.5%
1 Interest rate 50.5% 65.0%
2 Current 1.9% 4.0%
3 Other 4.3% 5.5%
但我只是想知道是否可以在不反复提及列名的情况下将最后3行放在一行中. 谢谢