Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between `sep` and `delimiter` attributes in pandas.read_csv() method?

What is the difference between sep and delimiter attributes in pandas.read_csv() method?

Also what is the situation when I would choose one over the other?

In documentation I read something about Python builtin sniffer tool, also in delimiter, it says alternative argument name for sep, then why cant we have only one attribute?

like image 839
GadaaDhaariGeek Avatar asked Mar 28 '18 11:03

GadaaDhaariGeek


2 Answers

Confirmation that they are the same thing can be found in the source code:

# Alias sep -> delimiter.
if delimiter is None:
    delimiter = sep

I agree with the other answer that it is best to stick to sep. It seems to be more commonly used, and it is more consistent with other functions such as to_csv, which does not accept delimiter, only sep.

like image 107
sjw Avatar answered Sep 22 '22 16:09

sjw


They're the same thing. See here.

I assume one is for backwards compatibility. I'd just use sep, it's what I see the most.

like image 20
FHTMitchell Avatar answered Sep 25 '22 16:09

FHTMitchell