非常大的.csv文件。转换为数组并使用，或插入到数据库中

import csv

def csv_to_array(file_path):
    data = []
    with open(file_path, 'r') as file:
        csv_reader = csv.reader(file)
        for row in csv_reader:
            data.append(row)
    return data

file_path = 'path/to/your/file.csv'
data_array = csv_to_array(file_path)

import csv
import mysql.connector

def insert_to_database(file_path):
    cnx = mysql.connector.connect(user='your_username', password='your_password',
                                  host='your_host', database='your_database')
    cursor = cnx.cursor()

    with open(file_path, 'r') as file:
        csv_reader = csv.reader(file)
        for row in csv_reader:
            # Assuming the CSV file has columns: column1, column2, column3
            query = "INSERT INTO your_table (column1, column2, column3) VALUES (%s, %s, %s)"
            cursor.execute(query, row)

    cnx.commit()
    cursor.close()
    cnx.close()

file_path = 'path/to/your/file.csv'
insert_to_database(file_path)