Reading an Excel file in python using pandas

Close: first you call ExcelFile, but then you call the .parse method and pass it the sheet name.

>>> xl = pd.ExcelFile("dummydata.xlsx")
>>> xl.sheet_names
[u'Sheet1', u'Sheet2', u'Sheet3']
>>> df = xl.parse("Sheet1")
>>> df.head()
                  Tid  dummy1    dummy2    dummy3    dummy4    dummy5  \
0 2006-09-01 00:00:00       0  5.894611  0.605211  3.842871  8.265307   
1 2006-09-01 01:00:00       0  5.712107  0.605211  3.416617  8.301360   
2 2006-09-01 02:00:00       0  5.105300  0.605211  3.090865  8.335395   
3 2006-09-01 03:00:00       0  4.098209  0.605211  3.198452  8.170187   
4 2006-09-01 04:00:00       0  3.338196  0.605211  2.970015  7.765058   

     dummy6  dummy7    dummy8    dummy9  
0  0.623354       0  2.579108  2.681728  
1  0.554211       0  7.210000  3.028614  
2  0.567841       0  6.940000  3.644147  
3  0.581470       0  6.630000  4.016155  
4  0.595100       0  6.350000  3.974442

What you’re doing is calling the method which lives on the class itself, rather than the instance, which is okay (although not very idiomatic), but if you’re doing that you would also need to pass the sheet name:

>>> parsed = pd.io.parsers.ExcelFile.parse(xl, "Sheet1")
>>> parsed.columns
Index([u'Tid', u'dummy1', u'dummy2', u'dummy3', u'dummy4', u'dummy5', u'dummy6', u'dum

Related Posts:

  1. how to reset index pandas dataframe after dropna() pandas dataframe
  2. What is the result of % in Python?
  3. Error: ‘int’ object is not subscriptable – Python
  4. Selecting multiple columns in a Pandas dataframe
  5. Python Variable Declaration
  6. How do I compare two strings in python?
  7. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  8. Pip freeze vs. pip list
  9. The difference between comparison to np.nan and isnull()
  10. Python pandas – filter rows after groupby
  11. Loading a file with more than one line of JSON into Pandas
  12. How to read the last line of a file in Python?
  13. Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
  14. TypeError: ‘int’ object is not subscriptable
  15. Renaming column names in Pandas
  16. What is the purpose of the word ‘self’?
  17. Behaviour of increment and decrement operators in Python
  18. Convert bytes to a string
  19. What is the use of “assert” in Python?
  20. Delete a column from a Pandas DataFrame
  21. How to uninstall pip on OSX?
  22. Python’s equivalent of && (logical-and) in an if-statement
  23. “inconsistent use of tabs and spaces in indentation”
  24. Referring to the null object in Python
  25. python .replace() regex [duplicate]
  26. SyntaxError: “can’t assign to function call”
  27. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  28. TypeError: ‘int’ object is not callable
  29. How to write the Fibonacci Sequence?
  30. How do I install pip on macOS or OS X?
  31. What is the necessity of plt.figure() in matplotlib?
  32. TypeError: ‘int’ object is not callable
  33. Modifing data while using iterrows() does not work
  34. Cannot find module cv2 when using OpenCV
  35. Converting dictionary to JSON
  36. What does `ValueError: cannot reindex from a duplicate axis` mean?
  37. ValueError: Unknown label type: ‘continuous’
  38. IndexError: tuple index out of range —– Python
  39. Create a Pandas Dataframe by appending one row at a time
  40. How to uninstall Python 2.7 on a Mac OS X 10.6.4?
  41. Cannot find module cv2 when using OpenCV
  42. Convert list to tuple in Python
  43. Pandas “Can only compare identically-labeled DataFrame objects” error
  44. Pandas: ValueError: cannot convert float NaN to integer
  45. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  46. ‘DataFrame’ object has no attribute ‘sort’
  47. What is dtype(‘O’), in pandas?
  48. Python TypeError: cannot convert the series to when trying to do math on dataframe
  49. IndexError: index 1 is out of bounds for axis 0 with size 1/ForwardEuler
  50. How to take column-slices of dataframe in pandas
  51. Python Pandas: Get index of rows which column matches certain value
  52. TypeError: unsupported operand type(s) for -: ‘list’ and ‘list’
  53. AttributeError: ‘datetime’ module has no attribute ‘strptime’
  54. Python add item to the tuple
  55. Group by index + column in pandas
  56. Converting binary to decimal integer output
  57. No module named setuptools
  58. Modify the legend of pandas bar plot
  59. Dropping Multiple Columns from a data frame using Python
  60. How to fix: “UnicodeDecodeError: ‘ascii’ codec can’t decode byte”
  61. Map to List error: Series object not callable
  62. Pandas DataFrame: replace all values in a column, based on condition
  63. How to convert string to datetime format in pandas python?
  64. Pandas – How to flatten a hierarchical index in columns
  65. What is the difference between json.load() and json.loads() functions
  66. Pandas OR statement ending in series contains
  67. What does sys.stdin read?
  68. Copy a list of list by value and not reference
  69. Why I get ‘list’ object has no attribute ‘items’?
  70. Python Pandas Error tokenizing data
  71. scrapy run spider from script
  72. python error: TypeError: an integer is required
  73. Groupby value counts on the dataframe pandas
  74. Pandas – Drop function error (label not contained in axis)
  75. Pandas index column title or name
  76. Python Requests – No connection adapters
  77. How to detect key presses?
  78. Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
  79. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  80. How to add pandas data to an existing csv file?
  81. Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
  82. ‘virtualenv’ is not recognized as an internal or external command, operable program or batch file
  83. Split string using a newline delimiter with Python
  84. No module named urllib3
  85. How to convert index of a pandas dataframe into a column
  86. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  87. pandas replace multiple values one column
  88. Convert floats to ints in Pandas?
  89. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  90. AttributeError: ‘tuple’ object has no attribute
  91. How to open html file?
  92. “Python version 2.7 required, which was not found in the registry” error when attempting to install netCDF4 on Windows 8
  93. Does python have header files like C/C++?
  94. Extract first and last row of a dataframe in pandas
  95. How can I find the dimensions of a matrix in Python?
  96. Python 2.7 mixing iteration and read methods would lose data
  97. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  98. What does an ‘r’ represent before a string in python?
  99. Extracting specific selected columns to new DataFrame as a copy
  100. Python: OSError: [Errno 2] No such file or directory: ”

Leave a Comment