Concatenating two different Data frames in Pandas Python

Asked Nov 29 '20 at 05:58

Active Nov 29 '20 at 13:28

Viewed 36 times

I am trying to add the below 2 data frames like below,writing the result to external file and by default the separator as comma(,) but I need the separator as space, any idea how to achieve this?

df16 = pd.DataFrame("    <SOURCE BUSINESSNAME ="'""'" DATATYPE ="'"'""+df2+""'"'">")
df18 = pd.DataFrame("NAME ="'"'""+df17+""'"'" />")

result = pd.concat ([df16]+[df18], axis=1)

result.to_csv('C:\\SAM\\TEST.dat',quoting=csv.QUOTE_NONE,header=0,index=False,mode='a+')

Actual Output:

<SOURCE BUSINESSNAME ="" DATATYPE ="CHAR"/>,NAME ="BA_RECCODE"

Expected Output:

<SOURCE BUSINESSNAME ="" DATATYPE ="CHAR"/> NAME ="BA_RECCODE"

edited Nov 29 '20 at 13:28

asked Nov 29 '20 at 05:58

Sam

Is all this strings doesnt make syntax error? – adir abargil Nov 29 '20 at 06:10
Welcome. [df16]+[df18] may be the cause of trouble. Try [df16, df18]. – Neeraj Hanumante Nov 29 '20 at 06:28
Does this answer your question? [How do I combine two data frames?](https://stackoverflow.com/questions/12850345/how-do-i-combine-two-data-frames) – CodeAllDay Nov 29 '20 at 06:33
I tried [df16, df18] but still I can't ignore comma(,) – Sam Nov 29 '20 at 13:29

Concatenating two different Data frames in Pandas Python

0 Answers0