Need help with my first soon to be in production prompt

Prompting
,
1

I’m new to this whole prompt engineering world and so far it’s been great and fun and actually for the first time in a while I’m enjoying a field in IT, anyway! back to the main problem. I’m currently tying to work on a prompt during my internship that aims to process some csv files and from its tables retrieve some information, in this prompt I’m using the system user assistant thing and I don’t know if I’m using it correctly since I found so little documentation on the subject so I’m looking for help here, here’s the prompt : [
{
“role”: “system”,
“content”: “You are an AI tool that performs actions and analysis on Excel and CSV files containing data related to actuary and alike.”,
},
{
“role”: “user”,
“content”: “”"
in this example you must perform step 1 on these tables :
—
Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8
—
ColumnA ColumnB ColumnC Column2 ColumnD ColumnE
—
“”"
},
{
“role”: “assistant”,
“content”: “”"
Step 1 :
Extracting the names of columns from the provided tables
- first table contains the following columns : (Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8)
- Second table contains these columns : (ColumnA ColumnB ColumnC Column2 ColumnD ColumnE)
“”"
},
{
“role”: “user”,
“content”: “”"
execute step 2 on the same example :
“”"
},
{
“role”: “assistant”,
“content”: “”"
Step 2 :
Finding relation between columns :
Table 1 :
- Column4 and Column6 have a realtion with column8
Table 2 :
- ColumnA is correlated with ColumnB and Column2
“”"
},
{
“role”: “user”,
“content”: “”"
execute step 3 on the same example :
“”"
},
{
“role”: “assistant”,
“content”: “”"
Step 3 :
Finding relations or associations between tables :
- There’s a one-to-many relationship between table 1 and table 2 on column2
“”"
},
{
“role”: “user”,
“content”: “”"
execute step 4 on the same example :
ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
“”"
},
{
“role”: “assistant”,
“content”: “”"
Step 4 :
Listing identified primary and secondary keys :
Table 1 :
- ColumnA can be a Primary key in this table
Table 2 :
- ColumnD is a Secondary key in this table
“”"
},
{
“role”: “user”,
“content”: “”"
On these tables

{information}

    You must perform only these tasks :
        - Step 1: Extract the names of columns containing data.
        - Step 2: Find relations between columns inside the same table.
        - Step 3: Find relarions between different files or tables.
        - Step 4: Identify primary and secondary keys based on the given data.
        - Step 5: In a case where no Primary keys where found, proceed to create a composed key from 2 or more columns. 
    """.format(information=information)
},
{
    "role": "user",
    "content": """
    Don't justify your answers.
    """
}
]
2

The AI will only answer the most recent user input.

Prior exchanges between a user and assistant are seen as older chat history.

In this case, that “history” is of little value, as it shows the AI operating differently than the latest user request.