Interview Task
Poke API data pull and SQL exploration
Tests: Python skills and SQL
Task 1 (mandatory)
Copyright By PowCoder代写 加微信 powcoder
• Create a python function which takes a list of Pokémon
names and returns a data frame with the ID (assigned as
index), name, type, weight and height.
a. Using the Requests library in Python collect the
data from the free PokeAPI.
b. Clean up the data by capitalizing the name and type.
c. Return one single data frame (Pandas/PySpark) with
the listed Pokémon.
• Be prepared to receive a new list of Pokémon from us to
run the function with during the second interview.
• You will need to explain your code and the decisions you
made so ensure you sufficiently comment and clean up
your code to make it more readable.
• We have listed some suggested libraries for you to use but
feel free to use others.
Bonus Task 1 (optional)
• Push the returned dataframe into BigQuery as a table
(BigQuery has a free option which should cover you
for the task). Hint: to push to BigQuery, you will need
to authenticate with either your user account or a
service account key within your BigQuery project.
Bonus Task 2 (optional)
• Suggest how you might go about setting up the
function to incrementally add only new Pokémon to
the BigQuery table (you don’t need to implement this)
Task 2 (Mandatory – to be completed during interview)
• Familiarise yourself with the data presented on this
website: SQL Tryit Editor v1.6 (w3schools.com)
• We will ask you to write a few SQL queries to answer
some questions during the interview.
• The key focus of this task is to test your skills in Joining,
Aggregating and Filtering the data between the tables in
the above link.
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com