Read CSV Using a Pipe Delimiter

Pandas is able to read a pipe delimited CSV file. This video will show you how to read flat files that have a unique delimiter.

Like I explain in the video, CSV (comma separated values) have a comma as the delimiter. And this is the default for the read_csv function. If you need to read in a file with a different delimiter, Pandas actually has a couple of parameters in the read_csv function to handle this situation.

The file is actually located in the web and we also get a chance to see how to read a file from a URL. As a bonus to this video, there also is step-by-step instructions on converting a date formatted string into an actual date object.

[ghrb]

Thank you. If delimiter is ";", then df=pd.read_csv("file name", sep=";") works.