为什么我的pandas数据帧有两个头

Question

def get_all_rows(conn):
df6 = pd.read_sql_query("SELECT * FROM Outofcountry", conn)
print(df6)
return

ComputerName              ConnectTime        lastExtIP  latestCountry          latestRegion    latestCity             Name  CurrentLogonUser  LastLogonUser  PrimaryUser    UserName
0      ComputerName      ConnectTime_decimal        lastExtIP  latestCountry          latestRegion    latestCity             Name  CurrentLogonUser  LastLogonUser  PrimaryUser  UserNamen

我想摆脱第二排。。。这是代码块：

def get_all_rows(conn):
df6 = pd.read_sql_query("SELECT * FROM Outofcountry", conn)
print(df6)
return

d1 = pd.read_csv("CS_Out_Of_Country.csv", mangle_dupe_cols='True', encoding='windows-1252')

我试着添加这个和False，但它对没有任何作用

希望它只是标题的一个输出：

ComputerName              ConnectTime        lastExtIP  latestCountry          latestRegion    latestCity             Name  CurrentLogonUser  LastLogonUser  PrimaryUser    UserName

Answer 1

在SQL表中，标头似乎出现了两次。你可以灰尘做：

df6.drop([0], inplace=True)