So, I thought as I have a bunch of data about our online appt system (no pt identifiable data), I'd thought I might ask ChatGPT to analyse it and do some proper work rather than just ask it stupid questions about how it spells Strawberry. I've tried uploading a CSV file (perfers them to .xlsx apparently), but it won't load, I've tried to make the file smaller, I've cleaned my cookies, done all the other suggestions that ChatGPT asks me to do, and still nothing
I'm wasting my time with this, aren't I?
Is using Microsoft Copilot an option? I'm a bit of an ignoramus, but believe my colleagues use it successfully for analysing xlsx data.
It is absolutely an option, I'll try that - we pay for ChatGPT (additional functionality apparently) which is why I asked about that specifically.
I use Co-pilot daily. Our enterprise data rules wont allow me to upload files but I can paste the data into the text box and ask it to analyse it. Have to say, it's an absolute game changer. Won't say it gives any better insights than me, but it does it a hell of a lot quicker
I almost posted this on the other AI thread, but I've had a lot of success with CoPilot processing CSV files.
I explained what each column contained and what output I wanted (timeline diagram, indicating resource conflicts). Not only did it produced what I asked, it made sensible suggestions for how to do it better!
After a bit of back and forth, rather than a static diagram, I now have an interactive webpage which lets me import the CSV, make changes in the diagram and then export a fresh CSV with the changes.
But your problem is with the actual data loading? You say you've already tried reducing data size etc..... have you tried cutting the 1st hundred lines and loading that alone?
Another Co-Pilot vote
Ditto Co-pilot. Been quite useful to me.
As ever, all about what you ask it to do, be smart with your inputs and how you word them.
have you tried cutting the 1st hundred lines and loading that alone?
Yeah did that, I just get a stalled loading bar and then a "Something went wrong" message after a few minutes. Co-pilot nailed it, thanks for the suggestion. It's just that we're paying for ChatGPT, so it's disappointing
It's actually pretty useful. It makes odd suggestions at first but once you give it more precise info you get better comments/output. Nothing surprising in the data, but It's saved a massive amount of time, and I haven't had to do any Excel wrangling.
It is very useful - for dumping things into and analysing, generating code along with explaining it, adding commentary etc,. Clearly not all AI based stuff is good but those who readily dismiss AI on the whole as a bad thing are probably not actually using it.
As ever, all about what you ask it to do, be smart with your inputs and how you word them.
Ask ChatGPT top writew the copilot prompt. ChatGPT is quite goos at understanding what you mean conversationally and translating it into AI propmpts
I know very little about this.
However, I have an online apt system, and ask a question, ‘who recommended you to book’ with options Google, family and friends, returning customer, and GP.
I wanted to know whether Google was worth the money, ie how many bookings it created.
I exported the whole diary to a spreadsheet where each appointment is a line. (My booking system does this)
I then just asked AI how I can analyse a particular column and it gave me step by step instructions on how to auto count each response type, and it worked, very little AI use as once you know how to the analysis was a thing the spreadsheet does.