I have a folder which contain three excel files and each excel file looks like this:

Country City Code Price

India Mumbai $423100$

India Mumbai $545200$

India Mumbai $664300$

India Mumbai $667400$

India Mumbai $443500$

India Mumbai $221600$

Country City Code Price

China Beijing $423250$

China Beijing $545289$

China Beijing $664310$

China Beijing $667420$

China Beijing $443550$

China Bejing $221606$

I need to insert a new row after code $664$ and the price will be $350.$ So new table will look like this:

Country City Code Price

India Mumbai $423100$

India Mumbai $545200$

India Mumbai $664300$

India Mumbai $665350$

India Mumbai $667400$

India Mumbai $443500$

India Mumbai $221600$

Country City Code Price

China Beijing $423250$

China Beijing $545289$

China Beijing $664310$

China Beijing $665350$

China Beijing $667420$

China Beijing $443550$

China Bejing $221606$

So$,$ all the excel files should be updated like that at the same time in one python script, because need to imagine there can be multiple excel files where we need to insert row in certain location. Could you please let me know how to do it in python jupyter notebook.I have a folder which contain three excel files and each excel file looks like this:

I need to insert a new row after code $664$ and the price will be $350.$ So new table will look like this:

So$,$ all the excel files should be updated like that at the same time in one python script, because need to

imagine there can be multiple excel files where we need to insert row in certain location. Could you

please let me know how to do it in python jypyter notebook.$|$