Skip to content

Tabular Framework

In NEXTgpt, we have implemented Tabular Query Framework to let users asks questions related to tabular data.

Data Flow

flowchart LR
    A[CSV File] -->C[Tabular Framework]
    B[User Query] --> C
    C --> |create csv command|D[REPL Tool] --> |output|C --> E[LLM Response]

How to use

Usecase Creation

You use the developer portal under the tab usecase creation or call the POST API.

Create Tabular Query use case by providing the parameters needed. We provide a sample usecase tabular

Usecase Test/Debug

You can test the usecase through the frontend or debug using the developer portal under the tab Debug.

How to use tabular usecase?

prepare and upload the CSV file of data.

sample of a csv with 10 rows, named customers-10.csv:

Index,Customer Id,First Name,Last Name,Company,City,Country,Phone 1,Phone 2,Email,Subscription Date,Website
1,DD37Cf93aecA6Dc,Sheryl,Baxter,Rasmussen Group,East Leonard,Chile,229.077.5154,397.884.0519x718,zunigavanessa@smith.info,24/8/20,http://www.stephenson.com/
2,1Ef7b82A4CAAD10,Preston,Lozano,Vega-Gentry,East Jimmychester,Djibouti,5153435776,686-620-1820x944,vmata@colon.com,23/4/21,http://www.hobbs.com/
3,6F94879bDAfE5a6,Roy,Berry,Murillo-Perry,Isabelborough,Antigua and Barbuda,-1199,(496)978-3969x58947,beckycarr@hogan.com,25/3/20,http://www.lawrence.com/
4,5Cef8BFA16c5e3c,Linda,Olsen,"Dominguez, Mcmillan and Donovan",Bensonview,Dominican Republic,001-808-617-6467x12895,-9892,stanleyblackwell@benson.org,2/6/20,http://www.good-lyons.com/
5,053d585Ab6b3159,Joanna,Bender,"Martin, Lang and Andrade",West Priscilla,Slovakia (Slovak Republic),001-234-203-0635x76146,001-199-446-3860x3486,colinalvarado@miles.net,17/4/21,https://goodwin-ingram.com/
6,2d08FB17EE273F4,Aimee,Downs,Steele Group,Chavezborough,Bosnia and Herzegovina,(283)437-3886x88321,999-728-1637,louis27@gilbert.com,25/2/20,http://www.berger.net/
7,EA4d384DfDbBf77,Darren,Peck,"Lester, Woodard and Mitchell",Lake Ana,Pitcairn Islands,(496)452-6181x3291,+1-247-266-0963x4995,tgates@cantrell.com,24/8/21,https://www.le.com/
8,0e04AFde9f225dE,Brett,Mullen,"Sanford, Davenport and Giles",Kimport,Bulgaria,001-583-352-7197x297,001-333-145-0369,asnow@colon.com,12/4/21,https://hammond-ramsey.com/
9,C2dE4dEEc489ae0,Sheryl,Meyers,Browning-Simon,Robersonstad,Cyprus,854-138-4911x5772,+1-448-910-2276x729,mariokhan@ryan-pope.org,13/1/20,https://www.bullock.net/
10,8C2811a503C7c5a,Michelle,Gallagher,Beck-Hendrix,Elaineberg,Timor-Leste,739.218.2516x459,001-054-401-0347x617,mdyer@escobar.net,8/11/21,https://arias.com/

Sample input query regarding the csv file:

List the customer ID, names, company and subscription date with subscription between December 2020 to April 2021

Sample Response:

Based on the given data, the following customers had their subscriptions between December 2020 and April 2021:

Customer Id: 1Ef7b82A4CAAD10 First Name: Preston Last Name: Lozano Company: Vega-Gentry Subscription Date: 23 April 2021

Customer Id: 053d585Ab6b3159 First Name: Joanna Last Name: Bender Company: Martin, Lang and Andrade Subscription Date: 17 April 2021