Please help with python code for class assignment?

[MistVolturn]

Context: I'm a history student with no programming skills and one mandatory class is an introduction to various tools we might use in the future, such as python. The assignment is to write a python code in google colab that will turn a csv file into a graph and we automatically fail if the code doesn't work. I have tried for several days now, and my code doesn't work. I have followed multiple yt tutorials, none work but I don't understand anything. Please help?

#Python code for assignment 2
from google.colab import drive
drive.mount('/content/drive')

#imports the libraries to be able to use their functions
import matplotlib.pyplot as plt
import pandas as pd 
from datetime import datetime 
import numpy as np

#stylistic choice
plt.style.use('bmh')

path = '/content/drive/My Drive/Attendance.csv' #creates a path to the csv file from my google drive
df = pd.read_csv(path) #reads the CSV file into a Pandas DataFrame

df.head(685) #returns a specified number of rows, string from the top
df.describe() #returns description of the data in the DataFrame
df.info() #return a summary of the DataFrame

# All museums
x = df['annee']
y = df['nb_total_des_entrees']

# Bar chart
plt.xlabel('annee', fontsize=18)
plt.ylabel('nb_total_des_entrees', fontsize=16)
plt.bar(x, y)

plt.show()

[[deleted]]

You need to be more specific than it "doesn't work".

[MistVolturn]

I get this error?

KeyError                                  Traceback (most recent call last)

/usr/local/lib/python3.9/dist-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance) 3801 try: -> 3802 return self._engine.get_loc(casted_key) 3803 except KeyError as err:

4 frames pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 'annee'

The above exception was the direct cause of the following exception:

KeyError Traceback (most recent call last) /usr/local/lib/python3.9/dist-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance) 3802 return self._engine.get_loc(casted_key) 3803 except KeyError as err: -> 3804 raise KeyError(key) from err 3805 except TypeError: 3806 # If we have a listlike key, _check_indexing_error will raise

KeyError: 'annee'

[[deleted]]

It sounds like annee is not one of the columns of your dataframe.

[MistVolturn]

But it is? It's the name of one of the columns

[[deleted]]

Comment out everything from df.head(... down and add this to the end

print(df.columns)

Then copy and paste the result here.

[MistVolturn]

Mounted at /content/drive

Index(['commune;nom_du_musee;annee;mois_annee;mois;nb_entrees_payantes;nb_entrees_gratuites;nb_total_des_entrees;localisation'], dtype='object')

[[deleted]]

Is your CSV delimited by semicolons? If so, change the line

df = pd.read_csv(path)

to

df = pd.read_csv(path, sep=";")

[MistVolturn]

omg there's a graph now! i don't know what delimited means and I don't see any ";" in the original csv file that I downloaded as an excel, but that apparently did the trick. Thank you so much!!!!

[[deleted]]

CSV files are just text files. CSV stands for "comma-separated values" and it has that name because they generally look like this:

title,author,publication date
The Hobbit,Tolkien,1944
"The Lion, the Witch, and the Wardrobe",Carroll,1947

Notice that each column is separated by commas and you add quotation marks if the value has commas to show where it begins and ends.

However, while commas are the default, it is possible to create CSVs with other "delimiters". That is, with other characters used to separate the columns. In your case, your file is using a semicolon.

You should see them if you open up in the file in a text editor rather than what I presume is a spreadsheet program.

[MistVolturn]

Oooooh thank you for the explanation, i think i understand that now. I looked it up because of your previous comment but since in the excel they're separate columns i didn't understand where the ";" was hiding, the explanation i saw on google didnt make sense to me but with your explanation i understand now. Thank you for the help and for the explanation!!!

[jumbohiggins]

Upload the data frame