Reading and storing data in different formats
In the following section, we will see how to read and store data in different formats.
Getting ready
Let's get started with the configuration of pandas.
Configuring pandas
We start with the standard imports and options for pandas to facilitate the examples:
How to do it...
We will see different ways on how to report data and how use it in different applications:
Working with CSV, text/tabular, and format data
CSV formatted data is likely to be one of the most common forms of data you may use in pandas. Many web-based services provide data in a CSV format, as do many information systems within an enterprise. It is an easy format to use and is commonly used as an export format for spreadsheet applications such as Excel.
A CSV is a file consisting of multiple lines of text-based data, with values separated by commas. It can be thought of as a table of data similar to a single sheet in a spreadsheet program. Each row of data is in its own line in the file...
