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 moduleimport pandas as pd # Creating a dictionary dit = {'August': [10, 25, 34, 4.85, 71.2, 1.1], 'September': [4.8, 54, 68, 9.25, 58, 0.9], 'October': [78, 5.8, 8.52, 12, 1.6, 11], 'November': [100, 5.8, 50, 8.9, 77, 10] } # Converting it to data framedf = pd.DataFrame(data=dit) # Original DataFramedf |
Output:
Converting the first column to series.
Python3
# Converting first column i.e 'August' to Seriesser1 = df.ix[:,0] print("\n1st column as a Series:\n")print(ser1) # Checking typeprint(type(ser1)) |
Output:
In the above example, we change the type of column ‘August‘ from the data frame to Series.
Case 2: Converting the last column of the data frame to Series
Python3
# Importing pandas moduleimport pandas as pd # Creating a dictionary dit = {'August': [10, 25, 34, 4.85, 71.2, 1.1], 'September': [4.8, 54, 68, 9.25, 58, 0.9], 'October': [78, 5.8, 8.52, 12, 1.6, 11], 'November': [100, 5.8, 50, 8.9, 77, 10] } # Converting it to data framedf = pd.DataFrame(data=dit) # Original DataFramedf |
Output:
Converting the last column to the series.
Python3
# Converting last column i.e 'November' to Seriesser1 = df.ix[:,3] print("\nLast column as a Series:\n")print(ser1) # Checking typeprint(type(ser1)) |
Output:
In the above example, we change the type of column ‘November‘ from the data frame to Series.
Case 3: Converting the multiple columns of the data frame to Series
Python3
# Importing pandas moduleimport pandas as pd # Creating a dictionary dit = {'August': [10, 25, 34, 4.85, 71.2, 1.1], 'September': [4.8, 54, 68, 9.25, 58, 0.9], 'October': [78, 5.8, 8.52, 12, 1.6, 11], 'November': [100, 5.8, 50, 8.9, 77, 10] } # Converting it to data framedf = pd.DataFrame(data=dit) # Original DataFramedf |
Output:
Converting multiple columns to series.
Python3
# Converting multiple columns # i.e 'September' and 'October' to Seriesser1 = df.ix[:,1]ser2 = df.ix[:,2] print("\nMultiple columns as a Series:\n")print(ser1)print()print(ser2) # Checking typeprint(type(ser1))print(type(ser2)) |
Output:
In the above example, we change the type of 2 columns i.e ‘September‘ and ‘October’ from the data frame to Series.
