如何使用Python和Pandas将csv文件中一个单元格的值复制到另一个csv文件中？

import pandas as pd

source_file = pd.read_csv('source.csv')
target_file = pd.read_csv('target.csv')

cell_value = source_file.loc[row_index, column_name]

target_file.at[row_index, column_name] = cell_value

target_file.to_csv('target.csv', index=False)

import pandas as pd

source_file = pd.read_csv('source.csv')
target_file = pd.read_csv('target.csv')

row_index = 0  # 假设源csv文件中所需值在第一行
column_name = 'Column1'  # 假设源csv文件中所需值在名为"Column1"的列

cell_value = source_file.loc[row_index, column_name]
target_file.at[row_index, column_name] = cell_value

target_file.to_csv('target.csv', index=False)