绘制一个 CSV 文件，其中分隔符是 ';'(分号 + 空格) [英] Plot a CSV file where the delimiter is '; ' (semicolon + space)

问题描述

我正在学习如何使用 import matplotlib.pyplot as plt 在Python中绘制事物(CSV文件).

I'm learning how to plot things (CSV files) in Python, using import matplotlib.pyplot as plt.

Column1;Column2;Column3;
1;4;6;
2;2;6;
3;3;8;
4;1;1;
5;4;2;

我可以用 plt.plotfile('test0.csv', (0, 1), delimiter=';') 绘制上图，得到下图.

I can plot the one above with plt.plotfile('test0.csv', (0, 1), delimiter=';'), getting the figure below.

如果我将分隔符从 ';'(分号)更改为 ','(逗号)，我也可以绘制该数据.

I can also plot that data if I change the separator from ';' (semicolon) to ',' (comma).

Column1,Column2,Column3,
1,4,6,
2,2,6,
3,3,8,
4,1,1,
5,4,2,

使用 plt.plotfile('test0.csv', (0, 1), delimiter=',').

但是没有设法在分隔符为'的地方绘制数据；(分号+空格)，如下所示.我还可以用 matplotlib.pyplot 拍这个还是该做点别的了?

But didn't managed to plot data where the separator is '; ' (semicolon + space), as show below. Can I still shoot this with matplotlib.pyplot or it's time to something else?

Column1; Column2; Column3; 
1; 4; 6; 
2; 2; 6; 
3; 3; 8; 
4; 1; 1; 
5; 4; 2; 

推荐答案

所以 matplotlib 抛出的错误是

So the error matplotlib is throwing you is

 TypeError: "delimiter" must be a 1-character string

这使得您似乎不太可能使用'；'.尝试 delimiter =';'时，我也抛出了错误，尽管您可能希望检查一下它是否可重现.

Which makes it seem very unlikely you can use '; '. I also had errors thrown when I tried delimiter=';' although you may wish to check that that is reproducible.

但是，如果可用，pandas可以使用 pd.read_csv 很好地处理此问题.

However pandas handles this just fine with pd.read_csv if you have it available.

import pandas as pd
alpha = pd.read_csv(filepath,delimiter=';')
alpha.Column1
0    1
1    2
2    3
3    4
4    5
Name: Column1, dtype: int64

这篇关于绘制一个 CSV 文件，其中分隔符是 ';'(分号 + 空格)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！