Working with data used to be a cumbersome task, but now arranging data has become much smoother, Thanks to ChatGPT. ChatGPT gives us an option to represent data in the form of charts and tables which enhances the precision and comprehensibility of the data, but it has its own set of limitations.
ChatGPT Plus is the premium version of chat GPT which costs nearly $20 per month. ChatGPT Plus provides incredible features, including built-in code execution and image generators. Tables can be generated in its free version. Some plugins are also available for data modification as an alternative to the default methods.
How to use ChatGPT to make charts and tables
Step 1: Decide what you want to make a table of
While utilizing the free version of ChatGPT to generate a table from publicly accessible information, keep note that the data has been trained through September 2021. Consequently, some alternations have to be made in the data while making the table.
Starting with instructing ChatGPT about your table requirement. It will execute any request without hesitation. Let’s assume, I prompted ChatGPT to generate a table of iconic and popular albums.
Step 2: Make any changes that you need
Modifications can be made to your table as per your will. Suppose, I asked ChatGPT to include the most popular song of each album in the table, ChatGPT will perform this in the blink of an eye.
Step 3: Visualizing the data
Now it’s time to change to ChatGPT Plus to utilize the data visualization tools. We can present the identical query to ChatGPT, to make a bar chart and it will execute the request happily.
Always cross-check the used data to verify its accuracy. Simply, commanding the tool to ‘generate vertical bar chart of data’.
Step 4: Supply your data
Key points while transferring your data,
Simply upload your CSV file to ChatGPT by clicking the paper clip button located to the left of the prompt input.
Instruct it to visualize the data. I utilized data collected during my Steam Deck review.
Describe your requirements. I asked to plot the gpu_temp column.
For those familiar with Python, ChatGPT provides Python code to generate the graphs.
Step 5: Manipulate, analyze, and export the data
ChatGPT can perform numerous tasks with datasets as per your instruction. For instance, I submitted a dataset containing U.S. Census Bureau information spanning from 2000 to 2019, and I could inquire about datasets from different aspects.
I requested:
A bar chart
A line graph
A change-over-time graph
A pie chart
For data manipulation, I asked to merge groups. For instance, I instructed ChatGPT to merge the 0-4 and 5-17 population age groups and represent them in a pie chart.
Getting ChatGPT to graph it
Simply Instruct ChatGPT to export the graph in high resolution. From all the graphs created, I asked ChatGPT to export the one I made while analyzing the data.
Creating tables is quite basic, but graphs are the simplest tables generated by ChatGPT 3.5. It works noticeably faster on a laptop, which gives benefits to programmers and data analysis using a laptop.