how to join 2 csv in spark ? i want to join 2 file of csv like in the picture and then i want to join the csv1 and csv2 become result. (please do it in google colab)

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

how to join 2 csv in spark ? i want to join 2 file of csv like in the picture and then i want to join the csv1 and csv2 become result.

(please do it in google colab)

CSV 1
user_id_sender
user_id_recipient
image_id
like
user002
user001
image001
user003
user001
image001
1
RESULT:
user004
user001
image001
user005
user001
image001
user_id_sender
age_sender
gender_sender
user_id_recipient
age_recipient
gender_recipient
image_id
like
user002
user001
image002
user002
30 Male
user001
image001
1
28 Female
user003
user001
image002
1
user003
18 Female
user001
28 Female
image001
1
user004
user001
image002
1
user004
40 Male
user001
28 Female
image001
1
user005
user001
image002
1
user005
30 Female
user001
28 Female
image001
user001
user002
image003
user002
30 Male
user001
28 Female
image002
1
user003
user002
image003
1
user003
18 Female
user001
28 Female
image002
user004
user002
image003
1
user004
40 Male
|image002
user001
28 Female
user005
user002
image003
1
user005
30 Female
user001
28 Female
image002
1
user001
28 Female
user002
30 Male
image003
CSV 2
user003
18 Female
user002
30 Male
image003
user004
40 Male
user002
30 Male
image003
1
user
age
gender
user005
30 Female
user002
30 Male
image003
user001
28 Female
user002
30 Male
user003
18 Female
user004
40 Male
user005
30 Female
Transcribed Image Text:CSV 1 user_id_sender user_id_recipient image_id like user002 user001 image001 user003 user001 image001 1 RESULT: user004 user001 image001 user005 user001 image001 user_id_sender age_sender gender_sender user_id_recipient age_recipient gender_recipient image_id like user002 user001 image002 user002 30 Male user001 image001 1 28 Female user003 user001 image002 1 user003 18 Female user001 28 Female image001 1 user004 user001 image002 1 user004 40 Male user001 28 Female image001 1 user005 user001 image002 1 user005 30 Female user001 28 Female image001 user001 user002 image003 user002 30 Male user001 28 Female image002 1 user003 user002 image003 1 user003 18 Female user001 28 Female image002 user004 user002 image003 1 user004 40 Male |image002 user001 28 Female user005 user002 image003 1 user005 30 Female user001 28 Female image002 1 user001 28 Female user002 30 Male image003 CSV 2 user003 18 Female user002 30 Male image003 user004 40 Male user002 30 Male image003 1 user age gender user005 30 Female user002 30 Male image003 user001 28 Female user002 30 Male user003 18 Female user004 40 Male user005 30 Female
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY