TECHNICAL CODING INTERVIEW QUESTIONS FOR A DATA ANALYST FRESHER

Follow me on LinkedIn, GitHub, YouTube

SOME TECHNICAL CODING INTERVIEW QUESTIONS FOR A DATA ANALYST FRESHER

-Anupam Shrivastava



1. Write a Python function to calculate the mean, median, and mode of a list of numbers.

2. Write a SQL query to find the top 5 products by sales revenue in a table named "sales_data", which has columns "product_id", "quantity_sold", and "unit_price".

3. Write a Python function to merge two sorted lists into a single sorted list.

4. Write a SQL query to calculate the percentage of orders that were delivered on time in a table named "orders", which has columns "order_id", "delivery_date", and "expected_delivery_date".

5. Write a Python function to find the most frequent item in a list.

6. Write a SQL query to calculate the average time between orders for each customer in a table named "orders", which has columns "order_id", "customer_id", and "order_date".

7. Write a Python function to remove duplicates from a list while preserving the order of the remaining elements.

8. Write a SQL query to calculate the percentage of customers who made repeat purchases in a table named "orders", which has columns "order_id", "customer_id", and "order_date".

9. Write a Python function to sort a list of tuples by the second element of each tuple.

10. Write a SQL query to find the number of orders and total revenue for each product in a table named "orders", which has columns "order_id", "product_id", "quantity_ordered", and "price_per_unit".

11. Write a Python function to find the top k elements from a list.

12. Write a SQL query to calculate the average revenue per order for each customer in a table named "orders", which has columns "order_id", "customer_id", "total_amount".

13. Write a Python function to flatten a nested list.

14. Write a SQL query to find the percentage of orders that included a discount in a table named "orders", which has columns "order_id", "customer_id", "order_date", and "discount_amount".

15. Write a Python function to calculate the factorial of a given number.

16. Write a SQL query to find the top n products by total revenue in a table named "orders", which has columns "order_id", "product_id", "quantity_ordered", and "price_per_unit".

17. Write a Python function to calculate the mean, median, and mode of a list of numbers.

18. Write a SQL query to find the number of customers who made their first purchase in a given month in a table named "orders", which has columns "order_id", "customer_id", and "order_date".

19. Write a Python function to find the common elements between two lists.

20. Write a SQL query to find the average time between orders for each product in a table named "orders", which has columns "order_id", "product_id", "order_date".



I trust that you have gained valuable insights from my blog.

Wishing you a fulfilling learning journey!

Thank you for reading. 


If you find my blogs informative and useful, please consider following me on 

GitHub (https://bit.ly/3ZFsW2E), 
and YouTube (https://bit.ly/3Jd0gss). [ Like, Share, & Subscribe ]

By following you'll receive notifications directly whenever I publish articles/post/videos on Python, Data Science, Machine Learning, SQL and more.

Comments

Post a Comment

Popular posts from this blog

10 DATA SCIENTIST INTERN INTERVIEW QUESTIONS WITH ANSWERS

Image
   Follow me on  LinkedIn ,  GitHub ,  YouTube 10 INTERVIEW QUESTIONS WITH ANSWERS & CODING EXAMPLES FOR DATA SCIENTIST INTERN ROLES -Anupam Shrivastava 1. What is your experience with data manipulation and analysis in Python? Answer: I have experience working with Python libraries like Pandas, Numpy, and Matplotlib for data manipulation, cleaning, and analysis. For example, I have used Pandas to merge and join datasets, remove duplicates and missing values, and transform data types. I have also used Numpy for numerical calculations and Matplotlib for data visualization. Code Example: 2. How do you handle missing values in a dataset? Answer: There are several ways to handle missing values, depending on the nature of the data and the analysis. One common approach is to remove any rows or columns with missing values using the dropna() method in Pandas. Another approach is to impute missing values with a mean, median, or mode value using the fillna() metho...
Read more

GENERATE A QR CODE FOR RESUMES USING PYTHON

Image
Follow me on  LinkedIn ,  GitHub ,  YouTube GENERATE A QR CODE USING PYTHON -Anupam Shrivastava You can use the qrcode library. You need to install the qrcode library before running this code. You can do so by running the following command in your terminal or command prompt: This code generates a QR code for the URL "https://codingwithas.blogspot.com/" and saves it as a PNG image named "example.png" in the same directory as the Python script. You can open the image file to view the QR code. There are many other options and customizations available in the qrcode library, such as adding color to the QR code, adding a logo to the QR code, specifying the size of the QR code, and more. You can refer to the qrcode documentation for more information and examples. You can Scan it and check QRCODE FOR MY RESUME: Generating a QR code for your resume is a great way to make it easier for potential employers to access your professional information quickly and easily....
Read more