Question: I am working on an assignment where I have two csvs. CSV1 contains a list of email addresses and CSV2 contains all order data including

I am working on an assignment where I have two csvs. CSV1 contains a list of email addresses and CSV2 contains all order data including customer email address. How could I use python to match the email addresses from CSV1 to those in CSV2 and create a new column with 0 for No Match and 1 for Match. I'd prefer to use Python for this but R code in addition to Python would be helpful. Ex. CSV1

abc@g**ail.com

123@hot***l.com

bcd@a**.com Ex. CSV2

Columns: Order ID, Order Date, Customer Name, Customer Email Address, Customer Shipping Address, Total Order Amount, Products Ordered.

Essentially I want to add a new column to CSV1 containing binary response of 0 (No Match) and 1 (Match) indicating whether the email address in CSV1 is present in CSV2.

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!

Student Name Enrolled ID. No MS 7004 Independent Study MS 7002 Thesis 1. Title: 2. Type of Research: 3. Background of the Research: 4. Research Objectives: 5. Research Questions: 6. Variables:...

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

Case Study: KALCH Distribution Company (KDC) Overview KDC is a regional transportation and distribution company in operation for over 60 years. The company serves major cities in the Mid-Atlantic...

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

Case Study: KALCH Distribution Company (KDC) Overview KDC is a regional transportation and distribution company in operation for over 60 years. The company serves major cities in the Mid-Atlantic...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

develop a memorandum addressed to the CFO that explains how you want to change your IT Department into a CIO organization and why. Your memo will address each of the topics listed below, and should...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Dealing with Ethical Issues The following are common situations faced by management and employees which can challenge ethical boundaries: Situation No. 1 - The employee responsible for procurement of...

Explain why PPP does not hold.

which type of fund should we invest in if we want to mirror the S&P 5 0 0

IRR: Mutually exclusive projects Nile Inc wants to choose the better of two mutually exclusive projects that expand warehouse capacity. The projects' cash flows are shown in the following table: The...

LAST WORD Over the years, the Federal Reserve Banks have printed many billions of dollars more in currency than U.S. households, businesses, and financial institutions now hold. Where is this missing...

KEY QUESTION What is meant when economists say that the Federal Reserve Banks are central banks, quasi-public banks, and bankers banks? What are the seven basic functions of the Federal Reserve...

KEY QUESTION When a commercial bank makes loans, it creates money; when loans are repaid, money is destroyed. Explain.