How to Convert Pandas DataFrame columns to a Series?

How to Convert Dataframe column into an index in Python-Pandas?

Last Updated : 21 Jul, 2021

Pandas provide a convenient way to handle data and its transformation. Let's see how can we convert a data frame column to row name or index in Pandas.
Create a dataframe first with dict of lists.

Python3

# importing pandas as pd
import pandas as pd

# Creating a dict of lists 
data = {'Name':["Akash", "Geeku", "Pankaj", "Sumitra", "Ramlal"],
       'Branch':["B.Tech", "MBA", "BCA", "B.Tech", "BCA"],
       'Score':["80", "90", "60", "30", "50"],
       'Result': ["Pass", "Pass", "Pass", "Fail", "Fail"]}

# creating a dataframe 
df = pd.DataFrame(data)
 
df

Output:

Method #1: Using set_index() method.

Python3

# importing pandas as pd
import pandas as pd

# Creating a dict of lists
data = {'Name':["Akash", "Geeku", "Pankaj", "Sumitra", "Ramlal"],
       'Branch':["B.Tech", "MBA", "BCA", "B.Tech", "BCA"],
       'Score':["80", "90", "60", "30", "50"],
       'Result': ["Pass", "Pass", "Pass", "Fail", "Fail"]}

# Creating a dataframe
df = pd.DataFrame(data)

# Using set_index() method on 'Name' column
df = df.set_index('Name')

df

Output:

Now, set index name as None.

Python3

# set the index to 'None' via its name property
df.index.names = [None]

df

Output:

Method #2: Using pivot() method.
In order to convert a column to row name or index in dataframe, Pandas has a built-in function Pivot. Now, let's say we want Result to be the rows/index, and columns be name in our dataframe, to achieve this pandas has provided a method called Pivot. Let us see how it works,

Python3

# importing pandas as pd
import pandas as pd

# Creating a dict of lists
data = {'name':["Akash", "Geeku", "Pankaj", "Sumitra", "Ramlal"],
       'Branch':["B.Tech", "MBA", "BCA", "B.Tech", "BCA"],
       'Score':["80", "90", "60", "30", "50"],
       'Result': ["Pass", "Pass", "Pass", "Fail", "Fail"]}

df = pd.DataFrame(data)

# pivoting the dataframe
df.pivot(index ='Result', columns ='name')

df

Output:

How to Convert Pandas DataFrame columns to a Series?

ankthon

Improve

Article Tags :

Practice Tags :

python

Similar Reads

How to convert index in a column of the Pandas dataframe?

Each row in a dataframe (i.e level=0) has an index value i.e value from 0 to n-1 index location and there are many ways to convert these index values into a column in a pandas dataframe. First, let's create a Pandas dataframe. Here, we will create a Pandas dataframe regarding student's marks in a pa

How to Convert Index to Column in Pandas Dataframe?

Pandas is a powerful tool which is used for data analysis and is built on top of the python library. The Pandas library enables users to create and manipulate dataframes (Tables of data) and time series effectively and efficiently. These dataframes can be used for training and testing machine learni

Convert a Dataframe Column to Integer in Pandas

Converting DataFrame columns to the correct data type is important especially when numeric values are mistakenly stored as strings. Let's learn how to efficiently convert a column to an integer in a Pandas DataFrameConvert DataFrame Column to Integer - using astype() Methodastype() method is simple

How to Convert Pandas DataFrame columns to a Series?

It is possible in pandas to convert columns of the pandas Data frame to series. Sometimes there is a need to converting columns of the data frame to another type like series for analyzing the data set.Â Case 1: Converting the first column of the data frame to Series Python3 # Importing pandas module

Convert a column to row name/index in Pandas

Pandas provide a convenient way to handle data and its transformation. Let's see how can we convert a column to row name/index in Pandas.Â Create a dataframe first with dict of lists.Â Python3 # importing pandas as pd import pandas as pd # Creating a dict of lists data = {'Name':["Akash", "Geeku", "

How to Convert Pandas DataFrame into a List?

In this article, we will explore the process of converting a Pandas DataFrame into a List, We'll delve into the methods and techniques involved in this conversion, shedding light on the versatility and capabilities of Pandas for handling data structures in Python.Ways to convert Pandas DataFrame Int

Python - Convert dict of list to Pandas dataframe

In this article, we will discuss how to convert a dictionary of lists to a pandas dataframe. Method 1: Using DataFrame.from_dict() We will use the from_dict method. This method will construct DataFrame from dict of array-like or dicts. Syntax: pandas.DataFrame.from_dict(dictionary) where dictionary

How to Convert String to Integer in Pandas DataFrame?

Let's see methods to convert string to an integer in Pandas DataFrame: Method 1: Use of Series.astype() method. Syntax: Series.astype(dtype, copy=True, errors=â€™raiseâ€™) Parameters: This method will take following parameters: dtype: Data type to convert the series into. (for example str, float, int).c

Count number of rows and columns in Pandas dataframe

In Pandas understanding number of rows and columns in a DataFrame is important for knowing structure of our dataset. Whether we're cleaning the data, performing calculations or visualizing results finding shape of the DataFrame is one of the initial steps. In this article, we'll explore various ways

How to Get the Common Index of Two Pandas DataFrames

When working with large datasets in Python Pandas, having multiple DataFrames with overlapping or related data is common. In many cases, we may want to identify the common indices between two DataFrames to perform further analysis, such as merging, filtering, or comparison.This article will guide us