如何从另一个文件（original.csv）向我的文件（modifiedFlights.csv）中再添加一列

Question

我想从另一个文件（original.csv）中添加一个names列，该文件（modifiedFlights.csv）有一个names列。目标是在比较两个文件中存在的hashes列之后，在modifiedFlights.csv中添加名称。但我不能这样做

import os
import glob
from pathlib import Path
import pandas as pd
import pandas
import csv
import numpy as np
from pandas import DataFrame
import sys, argparse, csv

hashes=pd.read_csv(r'C:\Users\Sajid\Desktop\original.csv', usecols=[0]) #hashes in original.csv
names=pd.read_csv(r'C:\Users\Sajid\Desktop\original.csv', usecols=[1])
this=pd.read_csv(r'C:\Users\Sajid\Desktop\csv files\modifiedFlights.csv', usecols=[4])# hashes in modifiedFlights.csv

for i in hashes:
    for y in this:
        if i == y:
            results_row=pd.read_csv(r'C:\Users\Sajid\Desktop\original.csv', usecols=[1], userows=[i])
            with open(r'C:\Users\Sajid\Desktop\csv files\modifiedFlights.csv','r') as csvinput:
                with open(r'C:\Users\Sajid\Desktop\out.csv', 'w') as csvoutput:
                    writer = csv.writer(csvoutput)
                    for row in csv.reader(csvinput):
                        writer.writerow(row+[result_row])