Upload CSV File to ChatGPT and Do Data Analysis without Code Interpreter Plugin

?Try Quadratic: http://quadratichq.com/?utm_source=youtube&utm_medium=referral&utm_campaign=pycoach In this video, we'll see how to upload files to ChatGPT and do data analysis without the code interpreter plugin - Code to add in the console: https://drive.google.com/drive/folders/1WM590IE-IKup_Fi27EHsnnnmOoDKTnsE?usp=sharing - CSV File: https://drive.google.com/drive/folders/12hFh6RPlX5bWzSqpoMvAeT94RCjCvHw5?usp=sharing - Prompt (Credits to "Automate My Life"): "Generate a Js script that creates a button with the text ‘Submit File’ and inserts it into the DOM before an element with the class ‘.flex.flex-col.w-full.py-2.flex-grow.md\:py-3.md\:pl-4’. The button should have a green background color, white text color, 5px padding, no border, 5px border radius and 5px margin. The script should also create a progress element and insert it into the DOM before the same element. The progress element should have a width of 99%, height of 5px and a grey background color. Inside the progress element, there should be another div element representing the progress bar with a width of 0%, height of 100% and blue background color. When the button is clicked, it should create an input element of type ‘file’ that accepts ‘.txt’, ‘.js’, ‘.py’, ‘.html’, ‘.css’, ‘.json’ and ‘.csv’ files. Once a file is selected, using an async it should be read as text and split into chunks of size 15000. using async Each chunk should be submitted into a conversation by doing the following: async function submitConversation(text, part, filename) { const textarea = document.querySelector("textarea[tabindex='0']"); const enterKeyEvent = new KeyboardEvent("keydown", { bubbles: true, cancelable: true, keyCode: 13, }); textarea.value = `Part ${part} of ${filename}: \n\n ${text}`; textarea.dispatchEvent(enterKeyEvent); }. The progress bar should be updated after each chunk is submitted within the for loop as follows progressBar.style.width = `${((i + 1) / numChunks) * 100}%`; and should also check if chatgpt is ready with this code: chatgptReady = false; while (!chatgptReady) { await new Promise((resolve) =＞ setTimeout(resolve, 1000)); chatgptReady = !document.querySelector( ".text-2xl ＞ span:not(.invisible)" Once all chunks have been submitted, the progress bar should turn blue." My Free Cheatsheets ================== ? Python Automation: https://frankandrade.ck.page/44559e1ae7 ? Python for Data Science Cheat Sheet: https://frankandrade.ck.page/26b76e9130 ? R for Data Science: https://frankandrade.ck.page/7b621bc82c ?️ SQL for Data Science:https://frankandrade.ck.page/f2fbbdc6db ? Web Scraping: https://frankandrade.ck.page/ca38420833 ? My FREE ChatGPT Cheat Sheet: https://frankandrade.ck.page/08c94cf1c1 ? My eBook “Code Less Earn More”: https://frankandrade.ck.page/3b520320ac Social Media =========== ? Discord: https://discord.gg/6xyQaj8bJK ? LinkedIn: https://www.linkedin.com/in/thepycoach/ ? Twitter: https://twitter.com/ThePyCoach ✏️ Medium: https://frank-andrade.medium.com/ ? GitHub: https://github.com/ifrankandrade My Courses ========== ? Join My Automation Course in Python: https://www.udemy.com/course/automate-your-life-with-python/?referralCode=7FA8B361D7A92B03A8C3 ? Join My Python for Data Science Bootcamp: https://www.udemy.com/course/python-for-data-science-bootcamp-2022-from-zero-to-hero/?referralCode=649B94757CB7A3A4756F ? 8-hour Web Scraping Course in Python: https://www.udemy.com/course/web-scraping-course-in-python-bs4-selenium-and-scrapy/?referralCode=291C4D7FF6F683531933 ? Make money by writing about AI, programming, data science or tech: https://thepycoach.teachable.com/p/medium Support My Work ============== ? PayPal: https://www.paypal.com/donate/?hosted_button_id=FV6C563QKSYGS -------------------- Content: 0:00 Intro 0:31 How to add the "Submit File" button 2:58 Data Analysis with ChatGPT 5:25 Visualization in ChatGPT and Wolfram Disclaimer: This video is sponsored by Quadratic