I’m trying to modify this pandas dataframe to output to a CSV file.
The output file will be used to upload data to another program so the file need to have specific headers for the data to be uploaded correctly.
This is the format needed for the CSV output file:
I’ve tried to modify the dataframe using pivot table and the following with no luck:
df2 = pd.get_dummies(SAMPDATA_w.set_index(['Sample ID', 'Sample Date', 'Result_F'])['ANALYTE']).groupby('Sample ID','ANALYTE').max().reset_index()
Any help would be appreciated.
Thanks
Is this the sort of thing you are looking for?
df_pivot = df.pivot_table(index=['Sample ID', 'Sample Date', 'Unit Of Detection'],
columns='ANALYTE', values='Result_F', aggfunc='first').reset_index()
print(df_pivot)
Let me know if it works for you.
1