In pandas, currently I'm doing this to append new row with index, but It doesn't make any changes in my CSV file

Question

import pandas as pd

read_csv = pd.read_csv('dse.csv')
read_csv.loc['new'] = ['Sunny', 'Programmer']

print(read_csv)

I want to update this new row and save this information in CSV file without losing previous data

Answer 1

Using df.to_csv's mode argument:

read_csv.to_csv('dse.csv', mode='a', header=False)