So, I downloaded the chemical dataset from the chembl database and needed to change the header in the csv as a column list so it can be easily read and analyze in google colab. Can anyone help me please?

I really appreciate it

the chemical dataset is look like this enter image description here

CodePudding user response：

From your comment it seems that the CSV is separated by semicolons. Maybe you can try reading it like this:

df = pd.read_csv("eugenol.csv", sep=";")

CodePudding user response：

check this link, can use pandas rename https://note.nkmk.me/en/python-pandas-dataframe-rename/#:~:text=You can use the rename,change column / index name individually.&text=Specify the original name and,index is for index name.