I wonder how to save a new pandas Series into a csv file in a different column. Suppose I have two csv files which both contains a column as a 'A'. I have done some mathematical function on them and then create a new variable as a 'B'.
For example:
data = pd.read_csv('filepath')
data['B'] = data['A']*10
# and add the value of data.B into a list as a B_list.append(data.B)
This will continue until all of the rows of the first and second csv file has been reading.
I would like to save a column B in a new spread sheet from both csv files.
For example I need this result:
colum1(from csv1) colum2(from csv2)
data.B.value data.b.value
By using this code:
pd.DataFrame(np.array(B_list)).T.to_csv('file.csv', index=False, header=None)
I won't get my preferred result.
Best Answer
Since each column in a pandas
DataFrame
is a pandasSeries
. Your B_list is actually a list of pandasSeries
which you can cast toDataFrame()
constructor, then transpose (or as @jezrael shows a horizontal merge withpd.concat(..., axis=1)
)And should csv have different rows, unequal series are filled with NANs at corresponding rows.