how to read excel based on column names and delete the header in python code example

Example 1: get rid of unnamed column pandas

df.to_csv(path, index=False)

Example 2: if a specific column name is present drop tyhe column

df.columns.str.startswith('Test')
# array([ True, False, False, False])

df.loc[:,~df.columns.str.startswith('Test')]

  toto test2 riri
0    x     x    x
1    x     x    x