Tried data.to_csv(sys.stdout,na_rep=’NULL’) but it doesnt apply to first row
>Solution :
That’s your index‘s name – it cannot be ignored.
Set index name instead using df.index.name = 'yourname' or remove the index from the to_csv using df.to_csv(index=False)