Analyse a dataset with an assistant that runs code
Gets an assistant that can run code to explore your data and show its working.
I’m attaching a file of [what the data is], with these columns: [the columns and what each means]. I want to know [your question]. 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.
Tips and an example: 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.