I am currently using PyCharm with Python version 3.4.3 for this particular project.
This PyCharm previously had Python2.7, and I upgraded to 3.4.3.
I am trying to fetch data from an Excel file using Pandas.
Here is my code:
import pandas as pd df = pd.read_excel("File.xls", "Sheet1") print (df)
When I ran this code, I am getting this error.
ImportError: No module named 'xlrd'
I searched Stackoverflow and found some suggestions: I tried with
pip install xlrd
But, when I did that, the message says
"Requirement already satisfied: xlrd in ./anaconda2/usr/lib/python2.7/site-packages"
Any suggestion?
Related Posts:
- How to install python3 version of package via pip on Ubuntu?
- pandas: merge (join) two data frames on multiple columns
- How to Read .txt in Pandas
- ‘End of statement expected’ in pycharm
- Type error: cannot convert the series to
- AttributeError: ‘Series’ object has no attribute ‘reshape’
- Moving Average Pandas
- matplotlib: plot multiple columns of pandas data frame on the bar chart
- How to print a specific row of a pandas DataFrame?
- SyntaxError: unexpected EOF while parsing
- TypeError: only integer scalar arrays can be converted to a scalar index with 1D numpy indices array
- Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat)
- How to install pip with Python 3?
- Import Error: No module named numpy
- How to deal with SettingWithCopyWarning in Pandas
- How to deal with SettingWithCopyWarning in Pandas
- TypeError: a bytes-like object is required, not ‘str’ when writing to a file in Python3
- Writing a pandas DataFrame to CSV file
- Best way to convert string to bytes in Python 3?
- ImportError: No module named pandas. Pandas installed pip
- Using Python 3 in virtualenv
- “Series objects are mutable and cannot be hashed” error
- Process finished with exit code -1073741515 (0xC0000135)
- WinError 2 The system cannot find the file specified (Python)
- Merging dataframes on index with pandas
- hashlib.md5() TypeError: Unicode-objects must be encoded before hashing
- Could not find a version that satisfies the requirement tensorflow
- Convert Python dict into a dataframe
- Local variable referenced before assignment?
- re.sub erroring with “Expected string or bytes-like object”
- How do I select rows from a DataFrame based on column values?
- DataFrame constructor not properly called! error
- AttributeError: ‘module’ object has no attribute ‘urlopen’
- Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
- ‘method’ object is not subscriptable. Don’t know what’s wrong
- TypeError: Missing 1 required positional argument: ‘self’
- What is __pycache__?
- TypeError: unsupported operand type(s) for -: ‘str’ and ‘int’
- pandas: filter rows of DataFrame with operator chaining
- Pandas how to use pd.cut()
- TypeError: can’t use a string pattern on a bytes-like object in re.findall()
- Pinging servers in Python
- What is the difference between Anaconda and Pycharm?
- Add Legend to Seaborn point plot
- How to pass arguments to a Button command in Tkinter?
- How to remove specific substrings from a set of strings in Python?
- Get total of Pandas column
- Change column type in pandas
- Why Am I Getting ELIF Invalid Syntax Error?
- How to remove punctuation marks from a string in Python 3.x using .translate()?
- Subplot for seaborn boxplot
- Why Python 3.6.1 throws AttributeError: module ‘enum’ has no attribute ‘IntFlag’?
- Python: pandas merge multiple dataframes
- How to load a tsv file into a Pandas DataFrame?
- How to count the NaN values in a column in pandas DataFrame
- How to use sys.exit() in Python
- Pandas – DataFrame object is not callable
- installing urllib in Python3.6
- What is sys.maxint in Python 3?
- Converting strings to floats in a DataFrame
- How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
- How to add an empty column to a dataframe?
- How to apply a function to two columns of Pandas dataframe
- What is the meaning of ‘for _ in range()
- Convert categorical data in pandas dataframe
- pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
- Youtube_dl : ERROR : YouTube said: Unable to extract video data
- AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas
- Insert a row to pandas dataframe
- Python Pandas ValueError Arrays Must be All Same Length
- Pycharm and sys.argv arguments
- Anaconda Installed but Cannot Launch Navigator
- How to save a Seaborn plot into a file
- ImportError: No module named ‘yaml’
- TypeError: ‘_io.TextIOWrapper’ object is not subscriptable
- Subtract two columns in dataframe
- pandas DataFrame: replace nan values with average of columns
- How to print multiple lines of text with Python
- Pandas error “Can only use .str accessor with string values”
- ImportError: No module named ‘cv2’ Python3
- What does {0} mean in this Python string?
- Tab Error in Python
- Python 3.5.1 urllib has no attribute request
- python pandas remove duplicate columns
- Why do I get this error “TypeError: ‘method’ object is not iterable”?
- What is the meaning of “int(a[::-1])” in Python?
- Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
- Python: Convert timedelta to int in a dataframe
- How to completely uninstall python 2.7.13 on Ubuntu 16.04
- Calculate weighted average using a pandas/dataframe
- Getting a name error when trying to input a string [duplicate]
- ValueError: multiclass format is not supported
- Error loading MySQLdb module: No module named ‘MySQLdb’
- How do you switch between python 2 and 3, and vice versa?
- Iterating over dictionary items(), values(), keys() in Python 3
- ValueError: Must pass DataFrame with boolean values only
- Simplify Chained Comparison
- Undefined variable error in function
- Python 3 integer division [duplicate]
- Python – difference between two strings