Hi!

Since a few weeks I have been trying out Python.

Currently I am struggling with reading an Excel-file with Python.

I use PyCharm.

Below is the error i get when. Someone has experience with this?

Traceback (most recent call last):

File "C:\Users\myname\PycharmProjects\pythonProject11\oefenen.py", line 2, in <module>

df = pd.read_excel('test.xlsx')

AttributeError: module 'pandas' has no attribute 'read_excel'

Process finished with exit code 1

The code:

import pandas as pd
import matplotlib.pyplot as plt
from matplotlib import style
style.use('ggplot')

web_stats = {'Day':[1,2,3,4,5,6],
             'Visitors':[43,53,34,45,64,34],
             'Bounce_Rate':[65,72,62,64,54,66]}

df = pd.DataFrame(web_stats)

print(df)

The error:

Traceback (most recent call last): File "C:/Users//OneDrive/Desktop/python/data analysis/pandas.py", line 1, in <module> import pandas as pd File "C:/Users//OneDrive/Desktop/python/data analysis\pandas.py", line 10, in <module> df = pd.DataFrame(web_stats) AttributeError: module 'pandas' has no attribute 'DataFrame'

I typed "DataFrame" correctly and even copy pasted the source code from the following website but it doesn't work: https://pythonprogramming.net/basics-data-analysis-python-pandas-tutorial/

I also ran "pip install pandas" on cmd and have python 3.7 installed.

I am trying to import a CSV file over to python but keep getting the following error. Any advice, I tried it on pycharm and juptyer notebook and get the same error. I am new to python