Analyse a dataset with an assistant that runs code

Tips for a better answer

• Use an assistant that can run code on files, and upload only data you’re allowed to share, with no names, emails or other personal details.
• Work out one key number yourself, such as one month’s total, to check the analysis.

An example, filled in

I’m attaching a file of three years of bookings for our holiday cottages, with guests’ names and contact details taken out, with these columns: booking date, first night, nights, cottage, party size, price paid, booked through (our website or an agency). I want to know which months and cottages bring in the most, and whether agency bookings are worth the agency’s fee. Before you analyse anything, describe the data (rows, columns, blanks and odd values) and ask me about anything unclear. Then analyse it step by step, showing the code you ran and the numbers behind every finding. Make one chart for the main finding. Finish with the limits of this analysis and everything you assumed, in plain English. Don’t remove or change any rows without telling me.