问Python :将序列追加到dataframe不会将数据放在正确的列中

EN

#=========================================================================================
#Start of program Setup
#=========================================================================================
consolidatedHeaders = ['Part_Number', 'Inspection_Routine', 'Inspection_Machine', 'Serial_Number', 'Timestamp', 'Feature', \
                       'LTL', 'Nominal', 'UTL', 'Observation', 'Tool', 'Machine', 'Rework', 'manual_intervention']

#=========================================================================================
#Creating the Consolidated file
#For my testing purposes, this file will not exist and is created with every execution of code
#=========================================================================================

consolidatedFileName = consolidatedPath + '\\' + YYYY + MM + '.csv'
    if not os.path.exists(consolidatedFileName): #Need to create a consolidated File
        with open(consolidatedFileName, 'w+') as c:
            c.seek(0)
            c.write(', '.join(consolidatedHeaders))
            c.write('\n')
            #c.truncate()
            c.close
#=========================================================================================
#Bits of irrelevant code here finding files that are candidates for import and consolidation
#=========================================================================================


#=========================================================================================
#We've now found a file, lets go through it and add each feature and accompanying data
#to a dataframe
#=========================================================================================
df = pd.DataFrame()#consolidatedHeaders, header=0) # This will hold the ingested data, adding headers here caused problems downstream

for each do something: #not actually in code, just showing that this is a loop
#=========================================================================================
#Loop through every feature within the file and append their data to df
#=========================================================================================
    observationInfo={'Part_Number' : partNumber, \
                     'Inspection_Routine' : inspectionRoutine, \
                     'Inspection_Machine' : inspectionMachine, \
                     'Serial_Number' : serialNumber, \
                     'Timestamp' : creationDate, \
                     'Feature' : nrpSplit[0][1:], \
                     'Nominal' : nrpSplit[1].strip(), \
                     'UTL' : nrpSplit[2].strip(), \
                     'LTL' : nrpSplit[3].strip(), \
                     'Observation' : nrpLines[whileIndex + 1].strip(), \
                     'Tool' : plhFeatureDF.get_value(0, 15, takeable=True), \
                     'Machine' : plhFeatureDF.get_value(0, 16, takeable=True), \
                     'Rework' : plhFeatureDF.get_value(0, 17, takeable=True), \
                     'manual_intervention' : plhFeatureDF.get_value(0, 18, takeable=True) \
                     }
    df = df.append(observationInfo, ignore_index=True)
#=========================================================================================
#df is now complete with each feature from the prior loop
#The following 'print(df.head())' shows the data in the correct columns exactly as it
#should be in the output file
#=========================================================================================

print(df.head()) #this shows the data exactly the way it should be

#=========================================================================================
#add df with ingested data to our consolidated .csv file
#=========================================================================================

with open(consolidatedFile, 'a+') as consolidate:
    df.to_csv(consolidate, header=False, index=False)

#=========================================================================================
#Problem!! When opening the resulting .csv file, The data is all in the wrong columns. The 
#columns are not in the order of "consolidatedHeader" that i used to create the file or 
#in the order of df which is appended to the file.
#=========================================================================================