In this program, we will see how to convert a series of lists of into one series, in other words, we are just merging the different lists into one single list, in Pandas. We will be using the stack() method to perform this task. The line will be Series.apply(Pandas.Series).stack().reset_index(drop = True). The reset_index() method will reset the index of the DataFrame/Series.
Example 1 : Merging multiple series lists of integers.
# importing the module import pandas as pd # creating a Pandas series of lists s = pd.Series([[2, 4, 6, 8], [1, 3, 5, 7], [2, 3, 5, 7]]) print("Printing the Original Series of list") print(s) # converting series of list into one series s = s.apply(pd.Series).stack().reset_index(drop = True) print("\nPrinting the converted series") print(s) |
Output :
Example 2 : Merging multiple series lists of characters.
# importing the module import pandas as pd # creating a Pandas series of lists s = pd.Series([['g', 'e', 'e', 'k', 's'], ['f', 'o', 'r'], ['g', 'e', 'e', 'k', 's']]) print("Printing the Original Series of list") print(s) # converting series of list into one series s = s.apply(pd.Series).stack().reset_index(drop = True) print("\nPrinting the converted series") print(s) |
Output :
<!–
–>
Converting Series of lists to one Series in Pandas
Add a Pandas series to another Pandas series
Python – Convert Lists into Similar key value lists
Python | Pandas Series.astype() to convert Data type of series
Convert a series of date strings to a time series in Pandas Dataframe
Creating a Pandas Series from Lists
Convert a NumPy array to a Pandas series
Pandas – Convert the first and last character of each word to upper case in a series
Convert given Pandas series into a dataframe with its index as another column on the dataframe
How to convert a Pandas Series to Python list?
Please Login to comment…