Question: Can you help me to write a python script which will create an excel file by combining two excel file I have two excel file

Can you help me to write a python script which will create an excel file by combining two excel file

I have two excel file Project File and State file.

Project file :

Project ID

State

3345

MN

7382

NC

2504

NC

3335

MN

1234

AZ

3467

AZ

9087

NC

4573

NY

2590

NY

State file:

Name

State

Jessica Mara

MN, NC

Schmid Cassie

AZ

Chad Hager

NY

With python script, please create a excel file combination of two excel file and output excel file will be like :

Project ID

State

Name

3345

MN

Jessica Mara

7382

NC

Jessica Mara

2504

NC

Jessica Mara

3335

MN

Jessica Mara

1234

AZ

Schmid Cassie

3467

AZ

Schmid Cassie

9087

NC

Jessica Mara

4573

NY

Chad Hager

2590

NY

Chad Hager

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Write a python script that will match two excel file based on State column and those matched rows as a list ,send to those responsible person who assign to that state through email as an attachment....

Q:

Write a python script that will match two excel files based on the State column and those matched rows as a list , send to those responsible people who assign to that state through email as an...

Q:

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Q:

I am in need of person skilled in Python and SQLite to help me with this problem. I have posted this several times on Chegg, but nobody has helped, and they all have not read my problem thoroughly...

Q:

Can someone skilled in Python and SQLite help me with this problem? I have posted this several times on Chegg, but nobody has helped. See the pertaining CSV file formats at the bottom of the problem:...

Q:

Can someone proficient in Python and SQLite help me with this problem? I have posted this several times on Chegg, but nobody has helped. See the CSV file formats at the bottom of the problem that are...

Q:

Can someone skilled in Python help me with this problem? I have posted this several times on Chegg, but nobody has helped. See the pertaining CSV file formats at the bottom of the problem: The...

Q:

I need help with Python. These are the functions created in a script. I don't need help with the functions. I need help with the problems that are done after the functions are created. I created the...

Q:

Using Python I can't figure it out the rest of the problem. What am I doing wrong on the one I'm getting errors on? These are the processes I created in the script. This is what I'm supposed to do in...

Q:

Write a python script that will pull data from Oracle SQL table and match it with an excel file and where name row match, send those rows to those people through email. Oracle SQL Table: Project...

Q:

Find the force of attraction between two magnetic dipoles, m1 and m2, oriented as shown in Fig. 6.7, a distance r apart, (a) Using Eq. 6.2, and (b) Using Eq.6.3. m r m

Q:

There are three parts for this question a. Explain why trading futures is very risky. You can center your discussion on leverage and margin. b. Discuss why it is highly risky when using options as an...

Q:

Problem 5 - 1 3 Calculating Interest Rates and Future Values [ LO 1 , 3 ] 1 1 . 1 1 pointseBookHintPrintReferencesIn 1 8 9 5 , the first U . S . Putting Green Championship was held. The winner's...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

1. What factors would determine what type of team is appropriate to look into the situation?

Q:

3. Who would the members be?

Q:

6. How might the team seek additional information from the community?