- 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
How to add column from another DataFrame in Pandas?
The insert() method is used to add a column from another DataFrame. At first, let us create our first DataFrame −
dataFrame1 = pd.DataFrame({"Car": ["Audi","Lamborghini", "BMW", "Lexus"], "Place": ["US", "UK", "India", "Australia"], "Units": [200, 500, 800, 1000]})
Now, let us create our second DataFrame −
dataFrame2 = pd.DataFrame({"Model": [2018, 2019, 2020, 2021], "CC": [3000, 2800, 3500, 3300]})
Car column added from DataFrame1 to DataFrame2
# Car column to be added to the second dataframe fetched_col = dataFrame1["Car"]
Example
Following is the code −
import pandas as pd dataFrame1 = pd.DataFrame({"Car": ["Audi", "Lamborghini", "BMW", "Lexus"], "Place": ["US", "UK", "India", "Australia"], "Units": [200, 500, 800, 1000]}) print("Dataframe 1...") print(dataFrame1) dataFrame2 = pd.DataFrame({"Model": [2018, 2019, 2020, 2021], "CC": [3000, 2800, 3500, 3300]}) print("Dataframe 2...") print(dataFrame2) # Car column to be added to the second dataframe fetched_col = dataFrame1["Car"] dataFrame2.insert(1, "LuxuryCar", fetched_col) print("Dataframe 2 (Updated):") print(dataFrame2)
Output
This will produce the following output −
Dataframe 1... Car Place Units 0 Audi US 200 1 Lamborghini UK 500 2 BMW India 800 3 Lexus Australia 1000 Dataframe 2... CC Model 0 3000 2018 1 2800 2019 2 3500 2020 3 3300 2021 Dataframe 2 (Updated): CC LuxuryCar Model 0 3000 Audi 2018 1 2800 Lamborghini 2019 2 3500 BMW 2020 3 3300 Lexus 2021
Advertisements