python - 如何从未命名的 :0 to columns with increment number in python 重命名列

Question

Df 之前:

    unnamed:0   unnamed:1  unnamed:2
0   Megan       30000      Botany
1   Ann         24000      Psychology
2   John        24000      Police
3   Mary        45000      Genetics
4   Jay         60000      Data Science

到 df 看起来像这样:

     t0       t1       t2
0   Megan  30000   Botany
1   Ann    24000   Psychology
2   John   24000   Police
3   Mary   45000   Genetics
4   Jay    60000   Data Science

我已尝试重命名未命名的列:

testfile.columns = testfile.columns.str.replace('Unnamed.*', 't')
testfile = testfile.rename(columns=lambda x: x+'x')

Answer 1

这将从 0 到您拥有的列数

testfile.columns = ['t{}'.format(i) for i in range(testfile.shape[1])]