知识问答

如何避免Python / Pandas在保存的csv中创建索引？

内容 隐藏
问题：如何避免Python / Pandas在保存的csv中创建索引？
回答 0
回答 1
回答 2
回答 3
回答 4
回答 5

问题：如何避免Python / Pandas在保存的csv中创建索引？

对文件进行一些编辑后，我试图将csv保存到文件夹。

每次我使用pd.to_csv('C:/Path of file.csv')csv文件时，都有单独的索引列。我想避免将索引打印到csv。

我试过了： 

pd.read_csv('C:/Path to file to edit.csv', index_col = False)

并保存文件…

pd.to_csv('C:/Path to save edited file.csv', index_col = False)

但是，我仍然得到不需要的索引列。保存文件时如何避免这种情况？

点击查看英文原文

I am trying to save a csv to a folder after making some edits to the file.

Every time I use pd.to_csv('C:/Path of file.csv') the csv file has a separate column of indexes. I want to avoid printing the index to csv.

I tried: 

pd.read_csv('C:/Path to file to edit.csv', index_col = False)

And to save the file…

pd.to_csv('C:/Path to save edited file.csv', index_col = False)

However, I still got the unwanted index column. How can I avoid this when I save my files?

回答 0

使用index=False。

df.to_csv('your.csv', index=False)
点击查看英文原文

Use index=False.

df.to_csv('your.csv', index=False)

回答 1

有两种方法可以处理我们不希望将索引存储在csv文件中的情况。

  1. 正如其他人所述，将 数据框保存到csv文件时可以使用index = False
    。

    df.to_csv('file_name.csv',index=False)

  2. 或者，您可以使用索引保存数据框，在读取时只需删除未命名的包含先前索引的0列即可！简单！

    df.to_csv(' file_name.csv ')
    df_new = pd.read_csv('file_name.csv').drop(['unnamed 0'],axis=1)

点击查看英文原文

There are two ways to handle the situation where we do not want the index to be stored in csv file.

  1. As others have stated you can use index=False while saving your
    dataframe to csv file.

    df.to_csv('file_name.csv',index=False)

  2. Or you can save your dataframe as it is with an index, and while reading you just drop the column unnamed 0 containing your previous index.Simple!

    df.to_csv(' file_name.csv ')
    df_new = pd.read_csv('file_name.csv').drop(['unnamed 0'],axis=1)

回答 2

如果不需要索引，请使用以下命令读取文件：

import pandas as pd
df = pd.read_csv('file.csv', index_col=0)

使用保存 

df.to_csv('file.csv', index=False)
点击查看英文原文

If you want no index, read file using:

import pandas as pd
df = pd.read_csv('file.csv', index_col=0)

save it using 

df.to_csv('file.csv', index=False)

回答 3

正如其他人所说，如果您不想首先保存索引列，则可以使用 df.to_csv('processed.csv', index=False)

但是，由于您通常使用的数据本身具有某种索引，因此我们假设使用“时间戳”列，因此我将保留索引并使用该索引加载数据。

因此，要保存索引数据，请首先设置其索引，然后保存DataFrame：

df.set_index('timestamp')
df.to_csv('processed.csv')

之后，您可以读取带有索引的数据：

pd.read_csv('processed.csv', index_col='timestamp')

或读取数据，然后设置索引：

pd.read_csv('filename.csv')
pd.set_index('column_name')
点击查看英文原文

As others have stated, if you don’t want to save the index column in the first place, you can use df.to_csv('processed.csv', index=False)

However, since the data you will usually use, have some sort of index themselves, let’s say a ‘timestamp’ column, I would keep the index and load the data using it.

So, to save the indexed data, first set their index and then save the DataFrame:

df.set_index('timestamp')
df.to_csv('processed.csv')

Afterwards, you can either read the data with the index:

pd.read_csv('processed.csv', index_col='timestamp')

or read the data, and then set the index:

pd.read_csv('filename.csv')
pd.set_index('column_name')

回答 4

如果要将此列保留为索引，则可以采用另一种解决方案。 

pd.read_csv('filename.csv', index_col='Unnamed: 0')
点击查看英文原文

Another solution if you want to keep this column as index. 

pd.read_csv('filename.csv', index_col='Unnamed: 0')

回答 5

如果您想要一个好的格式，那么下一条语句是最好的：

dataframe_prediction.to_csv('filename.csv', sep=',', encoding='utf-8', index=False)

在这种情况下，您将获得一个带有’，’的csv文件，该文件在各列和utf-8格式之间分开。另外，数字索引不会出现。

点击查看英文原文

If you want a good format the next statement is the best:

dataframe_prediction.to_csv('filename.csv', sep=',', encoding='utf-8', index=False)

In this case you have got a csv file with ‘,’ as separate between columns and utf-8 format. In addition, numerical index won’t appear.