First Assignment
Use Pandas Ai on Python
Pandas means Panel Data (data that goes into panels or database)
Learn about Pandas Ai
EDA with Ai
Start posting on Medium.com
Post projects on as you complete them
Minimum 2 per week
Smart Dataframe:
Combine Pandas & ChatGPT
Build a simple Saas solution for your industry
Voiceflow bot for contractor's or attorney's to get answers
Check The Valenzuala Group for Voiceflow bot they are using
To have the GPT analyze a PDF
upload PDF to OpenAi 'Files' in the settings section
is OCR image or text
Create a Medium article using ChatGPT (generate images with Ai also)
Prompt: Please create a formatted Medium.com article that is intuitive, includes code, prompts and make sure all code and prompts are explained. Please write on this topic.
Generative Ai assisted Data Analytics
Technical aspects of cleaning the data
Data content quality evaluation
Dealing with data error
Investigating unclear data
On Medium when posting add to the following topics:
Data Science, Machine Learning, Artificial Intelligence, Technology and ChatGPT.
Create a LinkedIn post with ChatGPT
Prompt: create a short attention grabbing LinkedIn post that refences the article located here: (add link to original Medium article here). The audience is college professors and students.
To keep copy of work you can ask the GPT to create a file to download. It can be an Excel, PDF or markdown format for Github post.
4. Create your own GPT
Generative Ai assisted data analytics
Prompt 1: Provide me with a complete Python code solution required to answer this question on the most common product categories in the dataset.
Prompt 2: Provide me with a complete Python code solution required to answer the question, "What are the most popular product categories in terms of sales volume and revenue, and how do their sales performance vary across different regions in Brazil?"
Prompt 3: Can you propose visualization methods for sales_by_region DataFrame, which would allow answering the posed research question?
Prompt 4: Can you propose visualization methods for sales_by_region DataFrame, which would allow answering the posed research question?
2. Learn Folium to build maps with Python
3. Use GPT to come up with a plan
Folium builds on the data wrangling strengths of the Python ecosystem and the mapping strengths of the Leaflet.js library. Manipulate your data in Python, then visualize it in a Leaflet map via Folium.
Folium makes it easy to visualize data that’s been manipulated in Python on an interactive leaflet map. It enables both the binding of data to a map for choropleth visualizations as well as passing rich vector/raster/HTML visualizations as markers on the map.
The library has a number of built-in tilesets from OpenStreetMap, Mapbox, etc, and supports custom tilesets. Folium supports both Image, Video, GeoJSON and TopoJSON overlays and has a number of vector layers built-in.
Set up an Azure account
Get free key from school
Ai Search
Semantic search application
Cognitive search
Azure is a cloud provider
MS Data Center lease virtual machine
Rent RAM, CPU, Disk
Frequency Analysis
Trigrams
Co-occurance Analysis
OpenAi to Prompt
Read the full chapter on drlee.ai