command to read file in python using pandas

Solutions on MaxInterview for command to read file in python using pandas by the best coders in the world

showing results for - "command to read file in python using pandas"
Andrea
23 May 2016
1import panda as pd 
2
3file_csv = pd.read_csv("file path")  ## as csv format
4file_excel = pd.read_excel("file path") ## as excel format
5file_json = pd.read_json("file path") ## as json format
6file_html = pd.read_html("file path") ## as html format
7file_localClipboard = pd.read_clipboard("file path") ## as clipboard format
8file_MSExcel = pd.read_excel("file path") ## as excel format
9file_HDF5 = pd.read_hdf("file path") ## as hdf5 fomrmat
10file_Feather = pd.read_feather("file path") ## as feather format
11file_msgpack = pd.read_msgpack("file path") ## as msgpack format
12file_stata = pd.read_stata("file path") ## as stata format
13file_SAS = pd.read_sas("file path") ## as SAS format
14file_paythonPickle = pd.read_pickle("file path") ## as paython_pickle format
15file_SQL = pd.read_sql("file path") ## as sql format
16file_google_big_query = pd.read_gbq("file path") ## as google big query