Combining two Series into a DataFrame in pandas

by

I think concat is a nice way to do this. If they are present it uses the name attributes of the Series as the columns (otherwise it simply numbers them):

In [1]: s1 = pd.Series([1, 2], index=['A', 'B'], name="s1")

In [2]: s2 = pd.Series([3, 4], index=['A', 'B'], name="s2")

In [3]: pd.concat([s1, s2], axis=1)
Out[3]:
   s1  s2
A   1   3
B   2   4

In [4]: pd.concat([s1, s2], axis=1).reset_index()
Out[4]:
  index  s1  s2
0     A   1   3
1     B   2   4

Note: This extends to more than 2 Series.

More Related Contents:

  1. error when applying function to a series object
  2. How to convert index of a pandas dataframe into a column
  3. Pandas filtering for multiple substrings in series
  4. df.append() is not appending to the DataFrame
  5. Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?
  6. Convert pandas Series to DataFrame
  7. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  8. how do I calculate a rolling idxmax
  9. Remove name, dtype from pandas output of dataframe or series
  10. Convert pandas data frame to series
  11. What is the fastest and most efficient way to append rows to a DataFrame?
  12. Compute the running (cumulative) maximum for a series in pandas
  13. Using replace efficiently in pandas
  14. Python Pandas iterate over rows and access column names
  15. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  16. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x
  17. Python Pandas – Find difference between two data frames
  18. Rename Pandas DataFrame Index
  19. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  20. How to check if any value is NaN in a Pandas DataFrame
  21. Convert row to column header for Pandas DataFrame,
  22. Apply CSS class to Pandas DataFrame using to_html
  23. How can I replicate rows in Pandas?
  24. Convert column to row in Python Pandas
  25. How to create a DataFrame of random integers with Pandas?
  26. Putting many python pandas dataframes to one excel worksheet
  27. Find difference between two data frames
  28. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  29. append dictionary to data frame
  30. Python: Adding hours to pandas timestamp

Leave a Comment