Python Data Analyst Interview Questions

10 python data analyst interview questions shared by candidates

What is the neighborhood in which superhosts have the biggest median price difference with respect to non superhosts? Use the following three columns in the 'listings' dataset to answer this question: 'host_is_superhost', 'neighbourhood_cleansed', and 'price'.
avatar

Python Data Analyst/Data Scientist

Interviewed at Turing

3.5
Oct 1, 2024

What is the neighborhood in which superhosts have the biggest median price difference with respect to non superhosts? Use the following three columns in the 'listings' dataset to answer this question: 'host_is_superhost', 'neighbourhood_cleansed', and 'price'.

Given the AirBnB dataset: https://colab.research.google.com/drive/1IwyaZuTccboR8huyWcxHKACTyFQBvHp5?usp=drive_link#scrollTo=I553tK0NAHtd Listings: This is a table that contains information about Airbnb listings in some city. Every listing has a single row in the table and contains several attributes related to the listing as well as the Airbnb host for the listing. Reviews: This is a table that contains information about all the guest reviews for the listings in the “Listings” table, along with related attributes such as the date of the review and the reviewer's name Answer the following questions:
avatar

Python Data Analyst/Data Scientist

Interviewed at Turing

3.5
Oct 1, 2024

Given the AirBnB dataset: https://colab.research.google.com/drive/1IwyaZuTccboR8huyWcxHKACTyFQBvHp5?usp=drive_link#scrollTo=I553tK0NAHtd Listings: This is a table that contains information about Airbnb listings in some city. Every listing has a single row in the table and contains several attributes related to the listing as well as the Airbnb host for the listing. Reviews: This is a table that contains information about all the guest reviews for the listings in the “Listings” table, along with related attributes such as the date of the review and the reviewer's name Answer the following questions:

What is the listing with the best expected revenue based on the last 12 months, considering 60% of guests leave reviews and every guest will stay only the minimum number of nights? Use both the 'listings' and 'reviews' datasets for this question and only use listings with minimum nights of stay <= 7. The 'minimum_nights' column indicates the required minimum number of nights of stay for any listing.
avatar

Python Data Analyst/Data Scientist

Interviewed at Turing

3.5
Oct 1, 2024

What is the listing with the best expected revenue based on the last 12 months, considering 60% of guests leave reviews and every guest will stay only the minimum number of nights? Use both the 'listings' and 'reviews' datasets for this question and only use listings with minimum nights of stay <= 7. The 'minimum_nights' column indicates the required minimum number of nights of stay for any listing.

What is the median price premium given to entire homes / entire apartments with respect to other listings of the same neighborhood? Report the average across all neighborhoods. Use the 'room_type’ column in the 'listings’ dataset to distinguish between entire homes / entire apartments and other types of listings
avatar

Python Data Analyst/Data Scientist

Interviewed at Turing

3.5
Oct 1, 2024

What is the median price premium given to entire homes / entire apartments with respect to other listings of the same neighborhood? Report the average across all neighborhoods. Use the 'room_type’ column in the 'listings’ dataset to distinguish between entire homes / entire apartments and other types of listings

What is the average price difference between a professional host and a non-professional one? Consider a host as professional if they have listings in more than 5 different locations (location is defined by the 'neighbourhood_cleansed' column).
avatar

Python Data Analyst/Data Scientist

Interviewed at Turing

3.5
Oct 1, 2024

What is the average price difference between a professional host and a non-professional one? Consider a host as professional if they have listings in more than 5 different locations (location is defined by the 'neighbourhood_cleansed' column).

Viewing 1 - 10 interview questions

Glassdoor has 10 interview questions and reports from Python data analyst interviews. Prepare for your interview. Get hired. Love your job.