如何将单个列作为数据帧内的标题传递：我面临错误：必须使用某种集合调用索引（…）

Question

我有一个下面的标题和一列字符串格式

col = cur.execute("select col_name from ColTable")
kp = []
for ak in col:
    column_name = str(ak[1]).replace("().","")
    for k in column_name.split():
        kp.append(k)

header = str(kp)[1:-1]

header = eval(header)


header = 'EmployeeId'

header = eval(header)

df = pd.dataframe(columns=header) 

我越来越

TypeError: Index(...) must be called with a collection of some kind, "('EmployeeId')" was passed

我还尝试了columns=list(header)，它正在创建问题，标题被划分如下

'E','m','p','l','e'...