python将一列的内容复制到另一列

Question

我正在尝试将CSV中某个列的内容复制到另一个CSV，我正在尝试下面的内容，但失败了

k1 = pd.DataFrame(k)
k1 = Dataframe['Category'] = Dataframe_name['Themes']
k1.to_csv(output_ticket_file)

请给我指点

Answer 1

听起来您只是想在CSV中移动列。在这种情况下，您可以简单地重命名该列

import pandas as pd

# Read data.
df = pd.read_csv("data.csv")
# Copy column.
df["Themes"] = df["Category"]
# Modify data as needed.

df.to_csv("changed_data.csv") 

Answer 2

将一列从数据帧复制到另一列非常容易：

#existing dataframe
df = pd.DataFrame(columns=['A', 'B', 'C'])

#new dataframe
df2 = pd.DataFrame()

#copy data from existing to new
#let a new column for df2 be called X
df2['X'] = df['A']