It is fairly unusual to create a DataFrame object from the raw data in a Python session. In practice, the data will often come from an external source, such as an existing spreadsheet or CSV file, database, or API endpoint. For this reason, pandas provides numerous utilities for loading and storing data to file. Out of the box, pandas supports loading and storing data from CSV, Excel (xls or xlsx), JSON, SQL, Parquet, and Google BigQuery. This makes it very easy to import your data into pandas and then manipulate and analyze this data using Python.
In this recipe, we will see how to load and store data into a CSV file. The instructions will be similar for loading and storing data to other file formats.
Getting ready
For this recipe, we will need to import the pandas package under the pdalias and the NumPy library as np, and we create a default random number generator from NumPy using the following commands:
...