import pandas as pd
import seaborn as sn
import matplotlib.pyplot as plt
from datetime import datetime
import numpy as np

df = pd.read_csv(r"C:\Users\bossd\OneDrive\Документы\datarn.csv")
df.drop(columns = df.columns[0], axis = 1)
display(df)

Everytime i want to delete the first column which always gets named 'Unnamed' and appears everytime i want to save changes with

每次我想要删除第一列时，它总是被命名为‘UNNAME’，并在每次我想要保存更改时出现

df.to_csv(r"C:\Users\bossd\OneDrive\Документы\datarn.csv")

And after i do this the column reappers or just doesn't delete, how do i delete these unnamed rows and save changes to a dataframe to be completely clear from these columns and have 'timestamp' as first column.

在我这样做之后，列将收获或不删除，我如何删除这些未命名的行并保存对数据帧的更改，以便完全从这些列中清除并将‘Timestamp’作为第一列。

(https://i.stack.imgur.com/Q66ha.png)

(https://i.stack.imgur.com/Q66ha.png))

Tried doing

试着去做

df = df.drop(columns = df.columns[0], axis = 1)

but it doesn't help me with this problem and the columns keep appearing

但这对我解决这个问题没有帮助，专栏不断出现

Also whenever i open the csv file i get this additional column that didn't exist before

此外，每当我打开CSV文件时，我都会收到以前不存在的附加列

(https://i.stack.imgur.com/jJ9WN.png)

(https://i.stack.imgur.com/jJ9WN.png))

What happens is when you are saving DF by default it adds an index column without a title hence the unmaned0 column appears in your DF when loading it again as this solution suggest you can delete multiple column with the same name but I'd like to add that when saving the DF to CSV -or any file format-
You can add index=False to not have an index column
for example:

发生的情况是，当您保存DF时，默认情况下它会添加一个没有标题的索引列，因此当再次加载它时，unmaned0列会出现在您的DF中，因为此解决方案建议您可以删除多个同名的列，但我想补充的是，在将DF保存为CSV或任何文件格式时，您可以添加index=False以没有索引列，例如：

df.to_csv(r"C:\Users\bossd\OneDrive\Документы\datarn.csv",index=False)

Solution

解

To drop multiple columns whose column name starts with 'Unnamed'

删除列名以“uname”开头的多个列

cols_to_drop = df.columns[df.columns.str.startswith('Unnamed')]

df.drop(cols_to_drop, axis=1, inplace=True)