Change it to list before assigning it to index
Copydf.index = list(df["First"])
Answer from Aman Singh Kamboj on Stack OverflowPandas
pandas.pydata.org › docs › reference › api › pandas.DataFrame.set_index.html
pandas.DataFrame.set_index — pandas 3.0.3 documentation
Set the DataFrame index (row labels) using one or more existing columns or arrays (of the correct length).
GeeksforGeeks
geeksforgeeks.org › pandas › python-pandas-dataframe-set_index
Python | Pandas DataFrame.set_index() - GeeksforGeeks
July 11, 2025 - Pandas set_index() method is used to set one or more columns of a DataFrame as the index. This is useful when we need to modify or add new indices to our data as it enhances data retrieval, indexing and merging tasks.
python - dataframe, set index from list - Stack Overflow
Note that passing arrays to set_index is very contentious among the devs and may even get deprecated. More on stackoverflow.com
python - pandas set_index() function returning None - Stack Overflow
I am attempting to change the index of this dataframe to 'Close Time' Open High Low Close Close Time 0 19183.87000000 19185.1100... More on stackoverflow.com
How to set index of pandas dataframe in python? - Stack Overflow
I have tried to choose a column to be an index of a data frame. The examples I've seen so far suggests to use the method set_index(), but it doesn't work in my case. I use python 3.7.0 import pand... More on stackoverflow.com
why do I need .set_index when pulling columns from a dataframe?
These are exactly equivalent powerlifting_meets.MeetID powerlifting_meets['MeetID'] But this one is something completely different powerlifting_meets.set_index('MeetID') The former will return a pandas.Series containing just the 'MeetId' column along with the original index of powerlifting_meetings. The latter will return a pandas.DataFrame with all the same columns as powerlifting_meetings, except that the 'MeetId' column will now be the index. So yeah, pandas.Series versus pandas.DataFrame, two totally different things. Based on this comment I want to create a var of just that column data Most likely you want the first of those two things, namely just the pandas.Series. If you want literally just the data values, not the entire pandas.Series object, you can do powerlifting_meets.MeetID.values More on reddit.com
4
2
October 14, 2021Videos
03:33
Pandas Set Index | pd.DataFrame.set_index() - YouTube
10:37
Pandas set_index() | Pandas DataFrame.set_index() | drop | inplace ...
Pandas - How I use the set_index() method - YouTube
02:32
Set Index of pandas DataFrame in Python (Example) | How to Convert ...
05:54
Load your data with the right index in Pandas (read_csv tips) - ...
Medium
medium.com › @noorfatimaafzalbutt › understanding-set-index-and-reset-index-in-pandas-6a1b7a27857c
Understanding set_index() and reset_index() in Pandas | by Noor Fatima | Medium
June 28, 2024 - In multi-level indexing, also known as hierarchical indexing, you can set multiple columns as the index. This is useful for more complex data structures where you need to identify rows uniquely by multiple keys. ... import pandas as pd # Sample DataFrame data = { 'animal': ['cat', 'cat', 'dog', 'dog'], 'breed': ['Siamese', 'Persian', 'Labrador', 'Beagle'], 'age': [2, 3, 7, 5], 'name': ['Whiskers', 'Fluffy', 'Buddy', 'Charlie'] } df = pd.DataFrame(data) # Set 'animal' and 'breed' as a multi-level index df_multi_index = df.set_index(['animal', 'breed']) print(df_multi_index)
CodeSignal
codesignal.com › learn › courses › python-libraries-for-data-analysis › lessons › navigating-dataframes-with-index-column-and-data-locating-in-pandas
Navigating DataFrames with Index Column and Data ...
Occasionally, we might need to establish a custom index. The Pandas' set_index() function allows us to set a custom index.
Top answer 1 of 2
1
When you're using inplace=True it will change the dataframe directly without returning the dataframe
So in your case it's either:
new_df = df.set_index('Close Time', drop=True)
print(new_df)
or
df.set_index('Close Time', inplace=True, drop=True)
print(df)
Can you show the output of the second one, since you said it didn't change it?
2 of 2
0
If you are reading from a file, use .read_csv(filename) to read the data frame. By the way, ignore the drop=True in your code as it is the default setting. So, it works just fine:
df.set_index('Close Time', inplace=True)
Stack Overflow
stackoverflow.com › questions › 55263066 › how-to-set-index-of-pandas-dataframe-in-python
How to set index of pandas dataframe in python? - Stack Overflow
pandas · indexing · Share · Short permalink to this question · Improve this question · Follow · Follow this question to receive notifications · edited Mar 20, 2019 at 14:25 · asked Mar 20, 2019 at 14:23 · Jacob Arén · 4111 silver badge44 bronze badges 3 · 2 · df = df.set_index('Fruit') jezrael – jezrael ·
W3Schools
w3schools.com › python › pandas › ref_df_set_index.asp
Pandas DataFrame set_index() Method
The set_index() method allows one or more column values become the row index.
Pete Houston
blog.petehouston.com › home › coding › programming tips › set index for dataframe in pandas
Set index for DataFrame in pandas ⋆ Pete Houston
March 20, 2019 - It is very common to see data engineers to set index for DataFrame in pandas; so, a function is made to help with this situation, set_index().
Pandas
pandas.pydata.org › docs › reference › api › pandas.Index.set_names.html
pandas.Index.set_names — pandas 3.0.3 documentation
>>> idx = pd.Index([1, 2, 3, 4]) >>> idx Index([1, 2, 3, 4], dtype='int64') >>> idx.set_names("quarter") Index([1, 2, 3, 4], dtype='int64', name='quarter')
Pandas
pandas.pydata.org › docs › reference › api › pandas.Series.index.html
pandas.Series.index — pandas 3.0.3 documentation
Conform Series to new index. ... The base pandas index type.
Spark By {Examples}
sparkbyexamples.com › home › pandas › pandas set index name to dataframe
Pandas Set Index Name to DataFrame - Spark By {Examples}
December 4, 2024 - Use pandas.DataFrame.rename_axis() to set the index name/title, in order to get the index use DataFrame.index.name property and the same could be used to
GeeksforGeeks
geeksforgeeks.org › python › how-to-change-index-values-in-pandas
How to Change Index Values in Pandas? - GeeksforGeeks
July 23, 2025 - Example 1: In this example, we perform a temporary change by setting 'AID' as the index without modifying the original DataFrame. This is the default behavior (inplace=False). ... import pandas as pd df = pd.DataFrame({ 'AID': ['AB101', 'AB102', 'AB103', 'AB104', 'AB105'], 'SID': ['21GFG1', '21GFG2', '21GFG3', '21GFG4', '21GFG5'], 'Name': ['Akhil', 'Mahesh Babu', 'Warner', 'Virat', 'ABD'], 'Ht': [5.9, 6.2, 5.6, 5.8, 5.10] }) df_temp = df.set_index('AID') print(df_temp) print("\nOriginal DataFrame:\n", df)
Note.nkmk.me
note.nkmk.me › home › python › pandas
pandas: Set a column as the DataFrame index with set_index() | note.nkmk.me
January 26, 2024 - The set_index() method of pandas.DataFrame allows you to set an existing column as the index (row labels). pandas.DataFrame.set_index — pandas 2.1.4 documentation How to use set_index()Basic usageKee ...
Reddit
reddit.com › r/learnpython › why do i need .set_index when pulling columns from a dataframe?
r/learnpython on Reddit: why do I need .set_index when pulling columns from a dataframe?
October 14, 2021 -
so a df named powerlifting_meets has a column indexed as MeetID, I want to create a var of just that column data
why do I need this ?
new = powerlifting_meets.set_index('MeetID')
why can't I just do this?
new = powerlifting_meets.MeetID OR new = powerlifting_meets['MeetID']
what purpose does the .set_index fills here? why is it being used a column name reference to get/pull the particular column in the df ?
Top answer 1 of 2
2
These are exactly equivalent powerlifting_meets.MeetID powerlifting_meets['MeetID'] But this one is something completely different powerlifting_meets.set_index('MeetID') The former will return a pandas.Series containing just the 'MeetId' column along with the original index of powerlifting_meetings. The latter will return a pandas.DataFrame with all the same columns as powerlifting_meetings, except that the 'MeetId' column will now be the index. So yeah, pandas.Series versus pandas.DataFrame, two totally different things. Based on this comment I want to create a var of just that column data Most likely you want the first of those two things, namely just the pandas.Series. If you want literally just the data values, not the entire pandas.Series object, you can do powerlifting_meets.MeetID.values
2 of 2
1
why do I need this ? Who told you that you need that? In what context? No one can guess, you have to provide more details. You don't need it. If you want the column data your second approach is correct. Using set_index doesn't make sense, it doesn't select the 'MeetID' column. If I would take a guess, you are misinterpreting someone else's code.
Medium
medium.com › @petehouston › set-index-for-dataframe-in-pandas-55400e306e42
Set index for DataFrame in pandas | by Pete Houston | Medium
March 20, 2019 - It is very common to see data engineers to set index for DataFrame in pandas; so, a function is made to help with this situation, set_index().
Pandas
pandas.pydata.org › docs › reference › api › pandas.DataFrame.html
pandas.DataFrame — pandas 3.0.3 documentation
>>> ser = pd.Series([1, 2, 3], index=["a", "b", "c"]) >>> df = pd.DataFrame(data=ser, index=["a", "c"]) >>> df 0 a 1 c 3
Pandas
pandas.pydata.org › docs › reference › api › pandas.DataFrame.index.html
pandas.DataFrame.index — pandas 3.0.3 documentation
>>> df = pd.DataFrame({'Name': ['Alice', 'Bob', 'Aritra'], ... 'Age': [25, 30, 35], ... 'Location': ['Seattle', 'New York', 'Kona']}, ... index=([10, 20, 30])) >>> df.index Index([10, 20, 30], dtype='int64') In this example, we create a DataFrame with 3 rows and 3 columns, including Name, Age, and Location information. We set the index labels to be the integers 10, 20, and 30.
Kaggle
kaggle.com › getting-started › 188103
Changing the Index using Pandas set_index
Checking your browser before accessing www.kaggle.com · Click here if you are not automatically redirected after 5 seconds
Appdividend
appdividend.com › pandas-set-index
Pandas DataFrame set_index(): Setting an Index Column
September 23, 2025 - The set_index() method in Pandas sets one or more existing columns of a DataFrame as its index (row labels).