Resolved: Exercise for clustering categorical data need to remove index column ........ (I NEED SOLUTION)
I need solve for this i try every thing what problem with this data
first i try >> data = pd.read_csv('your_data.csv', index_col='Unnamed: 0') when Loading data (not working)
second i try >> data.reset_index(drop=True, inplace=True) (not working)
third i try >> data = pd.read_csv('Categorical.csv' , index_col=0) (worked) but when i make some operation not get "continent" as 3 index in data
Thanks for reaching out.
The index of a
DataFrame are the labels that identify each row:
To the best of my knowledge, you can't remove these identifiers; you can only reset their count, as done in the lecture Linear Regression Practical Example (Part 5).
In fact, you shouldn't need to remove the index column from a
DataFrame. That would only be necessary if you want to export the
DataFrame to a CSV file excluding the index column. You can do this by introducing the parameter
index and setting it to
False, as follows:
data.to_csv('test.csv', index = False)
Hope this helps.