A fairly visually realistic human, although no Greg Egan or Terry Pratchett ![]()
Hi Nelson,
I have various google sheets or csv files containing the following data:
employeeID, forename,surname, dob,nationality
employeeID, start date, end date, name of direct manager
The idea would be to build a chatbot that could answers questions such as: Whatās the nationality of āxā, Whatās the birthdate of "employeeIDā etc
How would we go about it? I could not find any proper information so far. Is it even possible?
Hi @damibou
Itās very interesting you will like to try the GPT approach, because for this use case, it seems like traditional programming will work. However, if you were to do it with GPT, you can try something like thisā¦
Also, most likely you wonāt be able to fit the entire csv files into a single GPT prompt, you will need to implement an external system to find the matching data before including it into the prompt.
thanks for the quick reply! what type of external system would you recommend then?
- If you have a lot of structured data, you can store the CSV in SQL databases and write a couple simple API calls to search for the data and feed into GPT.
- If you need to search on unstructured data, then you will need to use semantic search which can be accomplish using the OpenAI Embedding API.
I created a google spreadsheet here that turns text data into embeddings and allow you to search directly inside google spreadsheet. You can then use the search result and send it the Completions API.
See Google Spreadsheet + GPT3 - #10 by nelson - Both of these options might not be the best solution, it really depends how your workflow is going to be. Feel free to reach out to me with your use case, itās likely there are better alternatives.
How would you recommend I go about adding the API into my software website, Iām not a coder so I have no experience in that field.
@johnpierref1 can you share more on how you plan to use the API for your website. Some examples and use cases would be helpful, thanks.
Saas B2B, helping other businesses.
Sure, feel free to message me or add me to your network on linkedin and we can chat more.
Thanks.
I donāt see an option to you PM u? Is there an option on here ?
Just PM u, we can connect there, thanks.
Hi Nelson I want a app using html to create website⦠can you be of help ?
@ASHABI03 can you tell me how far along you are and what kind of trouble you are running into?
Feel free to comment or drop me a message directly, thanks.
Hi there Nelson,
Iām probably too late for this party, but even so, thanks for your contributions here - when I see your name pop up I know itās going to be a very considered answer or comment!
Anyway, just in case, Iāll pose my question. Iām a bit of a ābigā thinker, so Iām probably biting off more than is chewable, but hey ho, Iām having fun learning about the AI! If nothing else, then a little comment as to your thoughts on these, and their viability/technical requirements would be cool - Iāve done some work on everything that I mention below. And sorry in advance ![]()
So, one of my particular thoughts is document classification and relationship building with the AI picking up the scent of something and informing the user that something else may be relevant. This is a real world and relevant to me project as itās a massive pain in my butt!
As an example (and this is what I really want to build it for), as a business we have audit standards (I work in the food and beverage manufacturing arena), and these are āhard codedā, but the implementation of them and the policies that we decide to update or change are not. As long as we achieve a result ,which may just be documentation of production for example, then we can update the policies.
The policy documents end up being a great many pages long. Theyāll include everything from personal hygiene to training records, from waste and pest control to ingredient traceability and allergen assessments. The key here is that so many of these are linked in some way.
For example, lets say that we choose to allow allergenic ingredients into the facility. Letās say itās Soy. Now we have to update personal hygiene policy for hand washing or PPE to make sure that thereās no cross contamination. Our Goods-In process now needs to include an āallergen?ā question. The warehouse now needs to store these separately from other ingredients. Cleaning procedures for machines need updating, labels on products, you get the idea.
Because of all this work, once itās done then either you donāt ever change what you do, or you āfudgeā it, or you spend hours and hours updating and checking, or you spend fortunes paying someone else to do it.
Hereās what Iād like the OpenAI to do:
Go through all the documentation. This will take time as thatāll chew up my token per hour limit! Break down the documents into types, and classify the sections within them, and then (and this is probably the really hard bit), try to understand the relationships between the sections so that if I want to change āXā it would say āoy! you need to have a look at A, B & K - thereās a high chance theyāll be impacted by the change.ā. Then, to really add sauce to it, wouldnāt it be lovely (and this might be the easiest part), for it to recommend some changes to the document. Itāll have the context, and if it understands the āwhyā enough to build the relationship between X & A then itāll probably be simple to spit out the desired policy update.
I know that thereāll be a whole load of training that will need to be done - I enter a document, it breaks it down, I comment on it, then itāll tweak it, itāll be better on the next document etc⦠Iām good with doing all that with it because itāll get a great result at the end! Iād imagined part of the solution as actually being an interactive training GUI with the AI giving its suggestions, and me updating it, accepting it or whatever.
Anyway, thatās a thought!
I have more (and these are all TLDRish):
- A google search result classifier: A chrome extension that offers clickable āalternative search termsā to expand or contract to give better search results. It would also classify the results (e.g. searching for Windows could mean panes of glass or the OS), and then you could select to only show the results from that classification.
- A GPT Code checker assimilator for when youāre using OpenAI to code something for you. A side-by-side GUI that has the GPT3 conversation, and then automatically pulls the code from the chat window and assess it in the other window and puts it where it should be. Especially useful in multi-part answers! Itāll tell you if it left something out that it had previously, or what variables have been changed, and even say if it thinks this is a good or bad update as IME when the model gets a train of thought then it canāt escape it and you have to start a new chat to clear its memory and get different answers. It would then have version control/history so as the code changes during the chat you can go back to previous compilations. I canāt code (at ALL), but Iāve been doing all kinds of stuff with GPT3, and keeping track and double checking it hasnāt missed or changed something because it āforgotā a part of the conversation or railroaded itself is a real nightmare!
- Local/Cloud File index and summary. If i have a boat load of documents then it would be great to have an AI summary of the contents of the files (a TLDR), all in a .Doc with hyperlinks. Which sheet had āXā in it? Instead of going through all your spreadsheets you could do a quick search in your .Doc, OR (fancy-pants), ask OpenAI to do that, and it can asses that if youāre looking for X, then Y documentās summary contains x, so would probably contain X too.
- Busy Man Email. Iāve done a little fine tuning of this model, but getting it to the next stageā¦hmmm. In short it acts as though youāre a āBusy Manā. It looks at your email and then classifies it as urgent/time sensitive in which case notify you NOW, or asses it into different categories with different resource requirements. Then you can select all the classifier ābankingā and do them all at once. It decides if itās a āpersonā writing the mail or an autosend (very easy to do!), and weighs people higher than auto unless X is in the auto email. It decides if a reply is needed so you can just select those when youāre next free to do so and do them first. Iāve not gone this far yet, but the ultimate goal is to get it to act as a PA and give you a to-do list for certain areas and then inform you as to how much time would need to be spent based on the volume or complexity etc., and maybe even blank out a spot in your calendar. It didnāt actually require a lot of training to get some pretty good results so far!
Sorry - deluge there, but the AI has SO much to offer and I have a million things that only a person or an AI can do!
All the best, and a Happy New Year to you Nelson!
Jon
Hi @JonL
Thank you for explaining in details the problem you are facing and the current approach you are looking into. Itās a very interesting problem, and Iāll like to brainstorm with you on how AI can help solve problems in the food industry. If you donāt mind, why do we a POC on a small use case and see if there are any opportunities we can solve this problem. Will love to hear back from you. Feel free to reach out to me on PM or linkedin.
https://www.linkedin.com/in/nelsonchu247
I have had this tutor who claimed he knew much more about web design using html and Iām really interested in doing this and I realize itās a waste of time and his far from what he said he is and ⦠all I could gain or learned is the basic things to do ā¦headlines ⦠background color and some little commands also ⦠and I really want to be good at this
I want to learn and be a pro in this feed and be part of this community!!
@ASHABI03 Welcome to the community. I remember learning to write html some 20 years ago, and it was exciting. But in my humble opinion, times has changed, so learning HTML might not be the best approach today. Depending on what your goal is, it might be better to learn new skills where most people are still unfamiliar with, so you can become the pro faster everyone else. Free free to reach out to me on PM or linkedin if you like to chat more.
Hi Nelson,
an example with explanation would be great.
We use custom code in C#.
Just dropped you a message with some sample code. We can try couple other options too if that wonāt work.
