I am new to python, pandas and mariadb and I need your help and advice, please.
I have a csv file that contains data with operations performed on every day of a month. I need to extract all the values ​​of a specific day and insert them into the database.
I thought of storing all the data in a DataFrame than I would then iterate and store the data of that day in another DataFrame, but I get the following warning:

```
The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

```

Here is my code so far:

```
import datetime as dt
import pandas as pd

data = pd.read_csv('./files/salesreport.csv',
                   names=['col_1', 'col_2', 'col_3', 'col_4', 'col_5', 'col_6',
                          'col_7', 'col_8', 'col_9', 'col_10'],
                   sep=',',
                   header=None,
                   keep_default_na=False,
                   na_values="")

df = pd.DataFrame(data)
pd.set_option('display.max_columns', None)

now = dt.datetime.now()
# today_date = now.strftime("%m-%d-%Y")

today_date = '07-17-2022' //i'm using this date for testing
tmp_df = pd.DataFrame()

for (index, row) in df.iterrows():
    if row.col_1 == today_date:
        tmp_df = tmp_df.append(row, ignore_index=True) 

```

I think my approach could also raise performance problems if the file is too big.
Can you please help me to find the best solution to be able to make the insert in the database only of the records specific to a certain day?
Also, can you tell me what is the best approach to make an insert in the database with MariaDB?

Thanks!