Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Combining two Series into a DataFrame in Pandas
To combine two series into a DataFrame in Pandas, we can take two series and concatenate them using concat() method.
Steps
Create series 1 with two elements, where index is ['a', 'b'] and name is Series 1.
Print Series 1.
Make Series 2 with two elements, where index is ['a', 'b'] and name is Series 2.
Print Series 2.
Concatenate Pandas objects along a particular axis with optional set logic along the other axes.
Print the resultant DataFrame.
Example
import pandas as pd s1 = pd.Series([4, 16], index=['a', 'b'], name='Series 1') print "Input series 1 is:
", s1 s2 = pd.Series([3, 9], index=['a', 'b'], name='Series 2') print "Input series 2 is:
", s2 df = pd.concat([s1, s2], axis=1) print "Resultant DataFrame is:
", df
Output
Input series 1 is:
a 4
b 16
Name: Series 1, dtype: int64
Input series 2 is:
a 3
b 9
Name: Series 2, dtype: int64
Resultant DataFrame is:
Series 1 Series 2
a 4 3
b 16 9
Updated on: 30-Aug-2021
2K+ Views
Advertisements