Do not index
Do not index
In this blog post, you will learn how to optimize your data for use with myBrain, allowing it to accurately answer questions based on data in tables.
By the end of this guide, you'll be able to transform your data into a structured format that myBrain can easily understand and process, ultimately improving the efficiency and accuracy of the AI's responses.
Step 1: Understand the Issue with Different Formats
myBrain struggles to answer questions when the data is in PDF or text formats because it's not structured well. The solution is to use a CSV format which forces a structure, making the data contextually relevant.
Step 2: Export Your Data as a CSV
Export your data as a CSV file from your table source, like Airtable, Google Sheets, or Excel. This will provide the structured format needed for myBrain to understand and process the information.
Step 3: Access myBrain’s CSV Upload Template
To access the CSV upload template, go to your myBrain’s dashboard, create a new myBrain project, and click on "?" followed by "Upload a CSV." Then, click on "Use our template" to access the CSV upload template.
Step 4: Follow the Template Instructions
Make sure to follow the template instructions, such as not having empty rows, including the content and title columns, not deleting any columns, and adhering to the character and row limits.
Step 5: Create Key-Value Pairs
Transform your data into key-value pairs for each item in the table. This will help myBrain understand the relationships between the different data points.
Step 6: Upload the CSV to myBrain
Once you have formatted your data according to the template, upload the CSV to myBrain. This will allow the system to effectively process the information and answer questions about the data in the table.
By following these steps, you'll be able to get your myBrain to answer questions on data in tables with more accuracy and efficiency.
Bonus (Macro)
This is the macro I used to reformat my table, just paste into Excel as a macro module, make sure your sheet with the table in is called Sheet1 and click ‘Run’.
Sub MergeHeaderAndDataForRange()
Dim ws As Worksheet
Dim dataRange As Range
Dim headerRange As Range
Dim lastCol As Long
Dim lastRow As Long
Dim i As Long
Dim j As Long
Dim result As String
' Set reference to the worksheet containing the data
Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to the name of your worksheet
' Find the last row and last column of the data
lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row
lastCol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
' Set reference to the header range
Set headerRange = ws.Range(ws.Cells(1, 1), ws.Cells(1, lastCol))
' Set reference to the data range (excluding the header row)
Set dataRange = ws.Range(ws.Cells(2, 1), ws.Cells(lastRow, lastCol))
' Loop through each row of the data range
For i = 1 To dataRange.Rows.Count
result = ""
' Loop through each column of the data range
For j = 1 To dataRange.Columns.Count
' Concatenate the header and data with line breaks
result = result & headerRange.Cells(1, j).Value & ": " & dataRange.Cells(i, j).Value & vbNewLine
Next j
' Write the result to the new column
ws.Cells(dataRange.Row + i - 1, dataRange.Column + lastCol).Value = result
Next i
End Sub