Maveryx Academy

A solution to last week’s challenge can be found here.  Source: www.californiaavocado.com/blog/avocado-fruit-or-vegetable   Love them or hate them, Avocados are a popular food that have been increasing in popularity. Did you know that they are technically a berry?   At any rate, this week's challenge is to find the regions with the largest increase (by percentage) of avocado consumption for [total volume] and each PLU code. PLU codes are the 4 digit codes which classify produce in retail stores. The final output should include both conventionally grown and organic results. ... View more

                        A solution to last week’s challenge can be found here. This challenge comes to us from @AkimasaKajitani . Thank you for your contribution, Aki!   Meteorite showers are a captivating natural phenomenon, though it can be challenging to see them depending on your location. Fortunately, residents and visitors in the Las Vegas area enjoy an advantageous position, being in proximity to expansive desert skies that offer excellent conditions for meteorite watching.   For this challenge, your mission is to plan a budget-friendly meteorite impact site tour near Las Vegas, ensuring enthusiasts visit locations where they have the best opportunity to witness this celestial spectacle.   Here are the tasks you must complete. Calculate all distances in kilometers.   Find a meteorite impact site that is closest to a hotel that costs less than $200 per night. Designate this location as the "First Stop." Identify the nearest meteorite impact site in relation to the First Stop. Label this site as the "Second Stop" and determine the distance between the first and second stops. Locate the nearest meteorite impact site in relation to the Second Stop. Name this site “Third Stop” and determine the distance between the second and third stops. Calculate the total distance traveled from the hotel to the third stop. Data Summary: You have two datasets. The text dataset contains the latitude and longitude of some hotels in Las Vegas with their cost per night. The second dataset, meteorite-landings.csv, contains the latitude and longitude of over 45,000 meteorites that have struck our planet.     Source: https://www.kaggle.com/datasets/nasa/meteorite-landings ... View more

A solution to last week's challenge can be found here!    Using the data provided in the start file, create an ordered list of the provided unofficial holidays.       GIPHY  Get ready for Answer the Phone like Buddy the Elf Day on December 18!  ... View more

A solution to last week’s challenge can be found here.   Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you.   The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average rating. Include the following columns in your list :   - Artist(s) - Number of albums (Descending) - Average rating based on all albums (Descending) - Album title(s) - Average number of reviews based on all albums (Descending) - Genre(s) - Year the first album was released - Year the last album was released Note: If in your solution you have null records for the Release Year, do not include them.   This challenge was updated to propose 2 start files and 2 solutions.   ... View more