#🔒 KeyCode Error with Predictive Algorithm
potent cove
coarse kelp
this kaggle's titanic?
I remember their features having capitalized characters, make sure to match that
keen dragon
well I have y set to a column in my dataset, the goal is to use a predictive algorithm (kmeans) and compare it to a dataset that has the correct answers, if the predictive algorithm is correct, it gets assigned a 1, if not then it stays at 0
keen dragon
this kaggle's titanic?
I remember their features having capitalized characters, ...
yes it is
but the kaggle website is missing a lot of information, ill try capitalizing
coarse kelp
check the df.head() df.columns, etc to see the column names
or even just read the .csv yourself, it's a very human readable format
keen dragon
well it runs fine but when i add that loop at the end it says error
and my csv is no caps
coarse kelp
well it runs fine but when i add that loop at the end it says error
well show the error then?
keen dragon
sorry program im using only shows small sliver of error message at a time
bottom one is probably more useful
it just doesnt like the prediction line
coarse kelp
I think it's here
prediction = kmeans.predict(X)
pred_df = pd.DataFrame({'actual': y, 'prediction': prediction})
print(pred_df)
for i in range(len(y+1)):
if prediction[i] == y[i]: # <--
correct += 1
```you can't access a `df` using index like that, you use `.iloc`>>> import pandas as pd, seaborn as sns
>>> df = sns.load_dataset('iris') # just some mock dataset
>>> df[0]
Traceback (most recent call last):
File "C:\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 3805, in get_loc
return self._engine.get_loc(casted_key)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "index.pyx", line 167, in pandas._libs.index.IndexEngine.get_loc
File "index.pyx", line 196, in pandas._libs.index.IndexEngine.get_loc
File "pandas\\_libs\\hashtable_class_helper.pxi", line 7081, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\\_libs\\hashtable_class_helper.pxi", line 7089, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 0
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:\Python311\Lib\site-packages\pandas\core\frame.py", line 4090, in __getitem__
indexer = self.columns.get_loc(key)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 3812, in get_loc
raise KeyError(key) from err
KeyError: 0
>>> df.iloc[0]
sepal_length 5.1
sepal_width 3.5
petal_length 1.4
petal_width 0.2
species setosa
Name: 0, dtype: object
>>>
so would i change the y to ship.iloc?
coarse kelp
so would i change the y to ship.iloc?
well anywhere you tried to access by index on a dataframe, you have to change it to use .iloc
keen dragon
gotcha
ive never used python before so this really hurts my brain
and theres no recent resources for this
coarse kelp
ive never used python before so this really hurts my brain
well python and the numpy/pandas/... family is very different
coarse kelp
and theres no recent resources for this
the official docs are pretty reliable
here's the indexing section of the user guide, on the part about indexing by position
keen dragon
gotcha, thanks homie
