Note
Click here to download the full example code
12.3.4.4. Getting data in/out¶
import pandas as pd
import numpy as np
timeStemps = pd.Series(np.random.randn(1000), index=pd.date_range("1/1/2000", periods=1000))
timeStemps = timeStemps.cumsum()
dataFrame = pd.DataFrame(np.random.randn(1000, 4), index=timeStemps.index, columns=["A", "B", "C", "D"])
dataFrame = dataFrame.cumsum()
dataFrame.to_csv("foo.csv")
pd.read_csv("foo.csv")
dataFrame.to_hdf("foo.h5", "df")
pd.read_hdf("foo.h5", "df")
dataFrame.to_excel("foo.xlsx", sheet_name="Sheet1")
pd.read_excel("foo.xlsx", "Sheet1", index_col=None, na_values=["NA"])
Total running time of the script: ( 0 minutes 0.647 seconds)