Video 10: Delimited Files (page 1 of 3)

Data have to be read into our Python scripts in order to perform any analyses. Data may be directly imported from a relational database such as MySQL or SQL Server, from a NoSQL database such as MongoDB or Couchbase, or from ascii text files. Here, we will work with ascii delimited text files. An ascii text file may be thought of as a sequence of lines that may be read and processed by our Python script. With delimited text files, each column is separated by a character. The below example shows a csv (comma separated values) file. Other common delimiters besides commas are pipes (|), semi-colons (;), and tabs.