append the data in python

Question

I have one csv file like this

out.csv
seedProductId,relatedProducts

My output is in dftype object looks like this

100A7E54111FB143    
100D11CF822BBBDB    
1014120EE9CCB1E0    
10276825CD5B4A26    
10364F56076B46B7    
103D1DDAD3064A66    
103F4F66EEB54308

I want to append this output with delimiter '|'.And I will pass another input as dynamic.

so I want the op like this

out.csv
seedProductId, relatedProducts
103F4F66EEB54308, 100A7E54111FB143 | 100D11CF822BBBDB | 10276825CD5B4A26 ...

Any help will be appreciated.

Why seedProductId is 103F4F66EEB54308? Because last item in output? — jezrael
– jezrael, Commented Jan 30, 2016 at 11:44
no I just mentioned for example purpose.I will pass the seedproduct id at run time — R.Aarthika Rajendran
– R.Aarthika Rajendran, Commented Jan 30, 2016 at 11:49
So you need only convert your output from many rows to one row separated by |? — jezrael
– jezrael, Commented Jan 30, 2016 at 11:54

jezrael · Accepted Answer · 2016-01-30 12:18:01Z

1

You can use cat for merging data, then create new Series for each columns and concat them. Last write output dataframe to file by to_csv:

print df
                  A
0  100A7E54111FB143
1  100D11CF822BBBDB
2  1014120EE9CCB1E0
3  10276825CD5B4A26
4  10364F56076B46B7
5  103D1DDAD3064A66
6  103F4F66EEB54308

seedProductId = "id790"
s1 = pd.Series(seedProductId, name='seedProductId')
print s1
0    id790
Name: seedProductId, dtype: object

relatedProducts = df.A.str.cat(sep='|')
print relatedProducts
100A7E54111FB143|100D11CF822BBBDB|1014120EE9CCB1E0|10276825CD5B4A26|10364F56076B46B7|103D1DDAD3064A66|103F4F66EEB54308

s2 = pd.Series(relatedProducts, name='relatedProducts')
print s2
0    100A7E54111FB143|100D11CF822BBBDB|1014120EE9CC...
Name: relatedProducts, dtype: object

df = pd.concat([s1, s2], axis=1)

print df.to_csv(index=False)
seedProductId,relatedProducts
id790,100A7E54111FB143|100D11CF822BBBDB|1014120EE9CCB1E0|10276825CD5B4A26|10364F56076B46B7|103D1DDAD3064A66|103F4F66EEB54308

answered Jan 30, 2016 at 12:18

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

jezrael Over a year ago

Ok, I think dftype object is for me dataframe with column A. But what is your dtfype object? Dataframe? Series? Something else?

jezrael Over a year ago

Yes, you can change it to relatedProducts = output['ProductId'].str.cat(sep='|')

R.Aarthika Rajendran Over a year ago

Hi nice.it works for me..I am now trying to append the output in my csv file

R.Aarthika Rajendran Over a year ago

the last line is not working for me..any help ? print df.to_csv(index=False)

jezrael Over a year ago

I think you need add filename df.to_csv("filename.csv", index=False)

|

Collectives™ on Stack Overflow

append the data in python

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related