The data was loaded from an Excel file, and after skipping the header row, relevant ratings data for two specific apps ('Crushed by Candies' and 'Chocolate Crossing') was filtered. An analysis comparing the average number of 5-star and 1-star ratings between these two apps was conducted using a bar plot.