The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Joins in the exercise

Joins in the exercise

0
Votes
1
Answer

Before doing the exercise I thought that going sales and reviews sheets in excel would be more appropriate, as excel is better than tableu for data processing. However, I had certain difficulties while doing it. Could you give quick tip on how to combine those two spreadsheets into one?

1 Answer

365 Team
0
Votes

Hi Emin, 
thanks for reaching out! To combine the two tables you need to join the two tables together. You could do that with the help of Tableau, Power Bi, or with SQL, for example. If you’d like to use Excel, you could try the merge option it provides. 
You can check out more on the topic from the following link:
https://www.ablebits.com/office-addins-blog/2018/10/31/excel-merge-tables-matching-columns/
Hope this helps!
 
Best, 
365 Eli

×
Online Data Science Training
SAVE 60%