In meinem Code:
Code: Alles auswählen
import pandas as pd
file_name = 'dm_input_niederlassungen.xlsx'
sheet_name = 'Tabelle1'
data = pd.read_excel(file_name)
df = pd.DataFrame(data)
writer = pd.ExcelWriter(file_name, engine='xlsxwriter')
df.to_excel(writer, sheet_name)
print(df.columns.values)
Code: Alles auswählen
['ID_Name : INT NOT NULL UNIQUE'
'ID_Strasse : INT NOT NULL UNIQUE.1'
'ID_Ort : INT NOT NULL UNIQUE.2']
Ich möchte gern:
Code: Alles auswählen
['ID_Name : INT NOT NULL UNIQUE'
'ID_Strasse : INT NOT NULL UNIQUE'
'ID_Ort : INT NOT NULL UNIQUE']
Wie macht man das?