Delete last row and index the sheet csv

 import pandas as pd

import os

link = pd.read_csv('/Users/jitendersingh/Documents/test.csv', squeeze=True,usecols=["Link", "Name" , "Status", "Image 1", "Image 2"])

new = link.reset_index() # add index in new file / try to run this code when upload new file

delete = link.drop(link.index[[0]],axis=0,inplace=True) #delete first row

save = link.to_csv('/Users/jitendersingh/Documents/test2.csv') #save file but index also deletes

os.remove('/Users/jitendersingh/Documents/test.csv')

link2 = pd.read_csv('/Users/jitendersingh/Documents/test2.csv', squeeze=True,usecols=["Link", "Name" , "Status", "Image 1", "Image 2"]) #again open file for correct index

new = link.reset_index() # correct index

save = link2.to_csv('/Users/jitendersingh/Documents/test.csv') #save file with correct index

os.remove('/Users/jitendersingh/Documents/test2.csv')

print (link)