10 IO Tools (Text, CSV, HDF5, ...)
Contents
- 10.1 Introduction
- 10.2 CSV & Text files
- 10.3 JSON
- 10.4 HTML
- 10.5 Excel files
- 10.6 Clipboard
- 10.7 Pickling
- 10.8 msgpack (experimental)
- 10.9 HDF5 (PyTables)
- 10.10 SQL Queries
- 10.11 Google BigQuery (Experimental)
- 10.12 Stata Format
- 10.13 SAS Formats
- 10.14 Other file formats
- 10.15 Performance Considerations
>>> import os
>>> import csv
>>> from pandas.compat import StringIO, BytesIO
>>> import pandas as pd
>>> ExcelWriter = pd.ExcelWriter
>>>
>>> import numpy as np
>>> np.random.seed(123456)
>>> randn = np.random.randn
>>> np.set_printoptions(precision=4, suppress=True)
>>>
>>> import matplotlib.pyplot as plt
>>> plt.close('all')
>>>
>>> import pandas.util.testing as tm
>>> pd.options.display.max_rows=15
>>> clipdf = pd.DataFrame({'A':[1,2,3],'B':[4,5,6],'C':['p','q','r']},
>>> index=['x','y','z'])