python - 如何获取 Pandas 指数位置和名称

Question

我想从 pandas DataFrame 中获取名称和索引位置，并进入如下逻辑，只是想知道是否有更好的方法来处理这个问题。

import pandas as pd

df = pd.read_csv('/docs/Credit_Card.csv', encoding='ISO-8859-1')
cols = df.columns
col = [df.columns.get_loc(c) for c in df.columns if c in cols]
print(pd.DataFrame(list(zip(cols, col)),columns=['index_Name', 'Index_Number']))

结果输出:

             index_Name  Index_Number
0        Card Type Code             0
1   Card Type Full Name             1
2          Issuing Bank             2
3           Card Number             3
4    Card Holder's Name             4
5              CVV/CVV2             5
6            Issue Date             6
7           Expiry Date             7
8          Billing Date             8
9              Card PIN             9
10         Credit Limit            10

Answer 1

用途:

import numpy as np

print(pd.DataFrame(list(zip(df.columns, 
                            np.arange(len(df.columns)))),
                   columns=['index_Name', 'Index_Number']))

类似于 numpy.c_ :

print(pd.DataFrame(np.c_[df.columns, np.arange(len(df.columns))],
                   columns=['index_Name', 'Index_Number']))

或者:

df1 = pd.Series(df.columns).reset_index()
df1.columns = ['Index_Number','index_Name']