From the course: Excel and ChatGPT: Data Analysis Power Tips

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Collaborate on data prep and EDA

Collaborate on data prep and EDA

- [Instructor] Alright, so one use case that I've been exploring that I'm really excited about and impressed with is using tools like ChatGPT and Bard to collaborate on things like data prep and exploratory analysis. It's such a great way to leverage the conversational nature of these tools and actually learn quite a bit along the way. So let me show you an example of what this might look like. Here in ChatGPT, I'm going to drop in a prompt like this. "I just exported a raw CSV file containing web traffic data. Could you please act like a data quality assurance engineer and give me a step-by-step plan to help me QA and prepare my data for analysis?" So you can see I'm really trying to set clear context here with this prompt. I'm describing the type of data that I'm analyzing. I'm specifying the role that I want ChatGPT to play, and I'm providing clear guidance on the type of output that I'm looking for, a step-by-step…

Contents