And how to overcome the various challenges it poses. One of the most amazing (and confusing) function of Google Sheets (or Microsoft Excel) is VLOOKUP.
One of the most amazing (and confusing) function of Google Sheets (or Microsoft Excel) is VLOOKUP. Although not perfect in any sense of the word, it does provide powerful features to join two different tables, or append one table with the values of another.
VLOOKUP is a function in spreadsheets which allows the user to establish a relationship between two tables. Let us try and understand it with an example.
Consider that you work as an analyst for an upcoming gaming studio and they want you to create a database of top selling game titles in the year 2002. Luckily for you, you found an amazing dataset with all the information and here is how it looks:
It contains information in two separate tables:
For more information on the above dataset, you can visit Kaggle.
How do we combine the two tables? We can simply copy and paste the values from one to the other. But look closely, the names are not in the same order in the two tables! Well, we can always copy and paste one by one. But that’s too much task! Why don’t we ask the spreadsheets to do it for us? Sounds like a plan! And this is where the almighty VLOOKUP function comes up!
How to send data from Google BigQuery to Google Sheets and Excel. Learn how to automatically and quickly send data from Google BigQuery to Google Sheets and Excel.
Data science is omnipresent to advanced statistical and machine learning methods. For whatever length of time that there is data to analyse, the need to investigate is obvious.
Automate Data Import to Google Analytics. Set up a data pipeline to import data to google analytics using Google Tentacles and GCP.
Who starts good ends even better? I am pretty sure that on your data journey you came across some courses, videos, articles, maybe use cases where someone takes some data.
In these articles, I’ll try to highlight some of the ways by which you can find data on the internet for free and then use it to create something meaningful out of it.