How to compare two data sets using ChatGPT | Scribe

    How to compare two data sets using ChatGPT

    • Patrick Law |
    • 18 steps |
    • 6 minutes
    • ChatgptChatgpt
    1
    In this guide, I will compare the calculated values for diameter and pressure drop from two separate line sizing calculations, using ChatGPT to analyze and contrast the results.
    2
    StepNavigate to <https://chatgpt.com/?model=gpt-4o>
    3
    Click a new calculation.
    4
    Enter this prompt:\ "I have an Excel file and a text-based file containing line-specific data for pipe diameters and pressure drops. Extract the following: *\[Line names (e.g., 'Oil-Water Mixture Entry Line').\ Pipe diameters (in mm, convert to this unit if needed) and pressure drops (in Pa) from both the Excel and text-based files.* *\ Organize the data into a table with columns:\ Line\ Pipe Diameter (Text-Based)\ Pipe Diameter (Excel-Based)\ Pressure Drop (Text-Based)\ Pressure Drop (Excel-Based).\ Put the line names in rows.\]* \ Ensure all values are properly aligned and all values for each parameter has the same unit.\ \ The goal is to: 1. **Extract Key Data**: Gather line-specific data for pipe diameters and pressure drops from both files. 2. **Standardize Units**: Ensure all diameters are in millimeters (mm) and all pressure drops are in Pascals (Pa). 3. **Organize Data**: Create a clear, tabular representation for easy comparison and analysis\ \ You can edit the values inside the bracket to depending on the information you want to extract from the documents. Here is the generalized version of the prompt:\ \ "Parameter 1 \[Specify Unit, give examples, additional information\] Parameter 2 \[Specify Unit, give examples, additional information\] Parameter 3 \[Specify Unit, give examples, additional information\]\ \ ..and so on Organize the data into a table with columns: Parameter 1 (Specify the file name/type)* Parameter 1 (Specify the file name/type)\ Parameter 2 (Specify the file name/type)\ Parameter 2 (Specify the file name/type)* Put the \[Parameter 3\] in rows\ \ Ensure all values are properly aligned and all values for each parameter has the same unit.**"**
    5
    Upload the two files to be compared.
    6
    Click here.
    7
    Click this icon.
    8
    Click here.
    9
    Then press enter.
    10
    Review the table generated.
    11
    After reviewing, enter this prompt to create clear, labeled visual representations of two key parameters (pipe diameter and pressure drop) for direct comparison between the text-based and Excel-derived data:\ \ "Using the table, create two line graphs for comparison: *\[Pipe Diameter Comparison: Show the pipe diameters from the text-based and Excel files for each line. Use the line names on the x-axis and pipe diameters (in mm) on the y-axis.\ Pressure Drop Comparison: Show the pressure drops from the text-based and Excel files for each line. Use the line names on the x-axis and pressure drops (in Pa) on the y-axis.\]*\ Ensure the graphs are clear and labeled."\ \ Here is a general version of the prompt: "Using the table, create two \[Graph Type\] graphs for comparison: *\[Parameter 1 Comparison: \[ Specify Instructions \]\ Parameter 2 Comparison: \[ Specify Instructions \]*\ Ensure the graphs are clear and labeled."
    12
    Review the graphs.
    13
    14
    You can then instruct ChatGPT to create an analysis on the discrepancies of the two calculations.\ \ "Examine the original documents. Create an analysis that detail the cause of the discrepancies in the graphs"
    15
    16
    17
    18
    Subscribe to our Youtube Channel and Udemy Course to learn more about using AI in your engineering workflow!