The AI Chatbot needs a lot of work on its alphabetization capability and on retaining and including all data set entries throughout a conversation.
I had to feed it a few rows at a time of my data from a txt file in CSV format.
I first explained that the first row is column group headings and the second row is column headings and the remaining rows are data.
Once I had entered all the heading rows and all the data rows, I asked it to alphabetically sort the entries by surname (one of the column names). The output showed the first few rows were in alphabetic order, but the subsequent rows were not sorted. The full output lacked a few rows and on each subsequent request to include all rows, it came back with less, or the same, until I finally told it how many rows it had and to include them all. Without such directions, it always comes back with a shorter and shorter list from the same data set.