How I use ChatGpt Code Interpreter as a Data Analyst

[@hankgrimes1806]

Kudos, Lore So What on a video well-done. BUT, even more captivating than the contents of the vid was your delivery. I teach English as a Foreign Language (35 yrs and counting), and I have to say that your language is positively mellifluous! While I'm captivated by the potential that ChatGPT holds for data analysis (I use it extensively to solve problems in Excel), I'm equally as curious about your journey to absolute fluency in English. I'm no slouch, but I'd be a very happy camper if my Spanish were as beautiful as your English. Again, good job on the vid - please keep 'em coming. And, if you wouldn't mind, I'd welcome a video about your data-analysis/language-learner journey.

[@loresowhat]

thanks a lot for your comment and the nice words!! took a lot of practice to be honest and my english is still not perfect ahah working on it! maybe I could you use your help too

[@hankgrimes1806]

@@loresowhat I'd be more than happy to assist in any way possible - it's in my blood. Lol! Would also love to run some ideas by you about how I'm using GPT in my teaching and in my own studies. Hit me up!

[@anthonycortes5]

Do you think it’d be helpful to include a project in my portfolio solely using ChatGPT? Maybe it’d be more useful if I didn’t use code interpreter because in a company, they prob wouldn’t want you uploading their exact info into ChatGPT, but I’ve found you can do so much with it only knowing small details about the data such as column names, etc. I’m thinking about doing this because I feel like it shows that I’m keeping up with the newest technologies and am capable. I would include the prompts used in ChatGPT, as well as everything else. Also, you mentioned it not being to do things that you can do in Tableau, but it can actually walk you through and help you build your visualizations in Tableau. Great video!

[@tahayassinemoumni4613]

Hey man , can I ask you how you create a portfolio ? I’m studying ds as well and wanna set it up too , if you could Imk I’d be really thankful

[@loresowhat]

amazing comment Anthony! If you can show how you used ChatGPT to contribute to a larger data analysis project (perhaps in combination with more traditional data analysis tools), that could make for a compelling portfolio piece. Ultimately, the purpose of your portfolio is to demonstrate your skills and aptitude in data analysis. If including a ChatGPT-based project helps to highlight your strengths and versatility as a data analyst, then it can be a good addition to your portfolio. Hope this helps and best of luck with your projects!

[@loresowhat]

I have videos on my channel where I create a data portfolio from scratch!! let me know if you can't find it

[@tahayassinemoumni4613]

@@loresowhat i just found it thanks !

[@JanghyunBaek]

Nice video. Could you share the “ interactive map” python code to run same as you? Thx

[@loresowhat]

Sure here it is, not the best to paste here but hopefully it’s still readable import pandas as pd import folium from folium.plugins import MarkerCluster # Load the US Cities dotaset df - pd.read_excel(uscities.xlsx) # Initialize the map m - folium.Map(location-[39.8283, -98.5795], zoom_start=4, contro # Create a marker cluster marker_cluster - MarkerClusterDadd_to(m) # Add markers to the map for - row in dfiterrows0: folium.Marker location=(row['lat'1, row['ing'D, icon=None, # Use the default marker icon ).add_to(marker_cluster) # Display the map M

[@wkc7936]

Nice Video! W/o internet access (as u can't have Code Interpreter and Web PlugIn on at same time) it's difficult to get a map of your data, even if it contains longitude and latitude coordinates. It was able to provide for the entire US, but when i tried to just have of it map within city counties of one state, Code Interpreter tells me that it can't do it w/o internet access. Do you've any suggestions on getting around this challenge?

[@loresowhat]

very good point! A workaround for your situation could involve preprocessing your data with geospatial libraries in Python like GeoPandas, Shapely or Folium. They can help you to generate static maps that you can include in your reports. let me know if that helps...

[@andycao966]

When using Code Interpreter to analyze probability and statistics data, can the final result allow Code Interpreter to directly generate a self-operating software for us (that is, implement the program: write the code for the data analysis program, including any necessary user interface and input/output mechanism, which we can then download to our PC for easy use.)? Thanks!

[@loresowhat]

Not yet, the output as of now is just a piece of code that you would need to run and host in a different environment

[@andycao966]

Thanks for your nice reply! Could you tell me how can I do that next?@@loresowhat

[@andycao966]

Good idea! Could you tell me which Open AI's tool (or other AI tools) can run and host that in a different environment for the rest job. Thanks!@@loresowhat

[@mayankverma6627]

Lore will it replace entry level data jobs?

[@loresowhat]

Not replacing but this is certainly changing how a data analyst will perform tasks

[@mayankverma6627]

@@loresowhat i think so now expectations in terms of productivity would higher but I still doubt companies gonna allow their data to be uploaded chatgpt

[@loresowhat]

absolutely agree with you!

[@lucadelli9308]

lore pensi che questo possa rovinare il lavoro di DA e ridurre il numero di assunzioni?

[@loresowhat]

bella domanda... credo che di sicuro verra' introdotto in molte aziende presto e un data analyst dovra' capire sempre meglio come usare generative AI e prompt engineering nel day to day... tu che dici?

[@achilleconte4385]

come viene fatto notare dai commenti qui sopra, esiste un problema di regolamentazione della privacy e utilizzo dei dati, per cui normativamente le aziende (specialmente quelle + grandi) finiranno per proibirlo nel breve/medio periodo, fin quando non avranno delle certezze legali. Detto questo, ChatGPT "conosce" solo database datati settembre 2021, quindi non potrà darti una risposta corretta riguardo innovazioni o informazioni molto recenti.

[@loresowhat]

completamente d'accordo e posso aggiungere che sempre piu' societa' formeranno la loro versione personalizzata di chatGPT (come stiamo gia' vedendo adesso)

[@ytpah9823]

what is the purpose of the annoying background "music" used in youtube videos?

[@loresowhat]

Thanks for the feedback and I was actually thinking if I should remove the background sound. Will test it from the next video 👍