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, Jan 30 '16 at 11:44
no I just mentioned for example purpose.I will pass the seedproduct id at run time — R.Aarthika Rajendran, Jan 30 '16 at 11:49
So you need only convert your output from many rows to one row separated by `|`? — jezrael, Jan 30 '16 at 11:54
yes..can u help me how to write the object into file with delimiter — R.Aarthika Rajendran, Jan 30 '16 at 12:17

score 1 · Accepted Answer · answered Jan 30 '16 at 12:18

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 '16 at 12:18

jezrael

822,522
95
1,334
1,252

Ok, I think `dftype object` is for me dataframe with column `A`. But what is your `dtfype object`? Dataframe? Series? Something else? – jezrael Jan 30 '16 at 12:26
Yes, you can change it to `relatedProducts = output['ProductId'].str.cat(sep='|')` – jezrael Jan 30 '16 at 12:34
Hi nice.it works for me..I am now trying to append the output in my csv file – R.Aarthika Rajendran Jan 30 '16 at 12:38
the last line is not working for me..any help ? print df.to_csv(index=False) – R.Aarthika Rajendran Jan 30 '16 at 13:07
I think you need add filename `df.to_csv("filename.csv", index=False)` – jezrael Jan 30 '16 at 13:12
last doubt is it possible to pass arguments to my program.. rating_toby = rp['1021C789EC57BBC1'] I need to pass like this rating_toby = rp['param'] – R.Aarthika Rajendran Jan 30 '16 at 13:28
Maybe you can create variable `param` - `param='1021C789EC57BBC1'` and then use it: `rating_toby = rp[param]` – jezrael Jan 30 '16 at 13:40
no not like this .I am going to execute like this python filename.py (here i need to define the argument) – R.Aarthika Rajendran Jan 30 '16 at 13:44
`rp` is function? is defining like `def rp()` ? – jezrael Jan 30 '16 at 13:49
Hmmm, maybe you think [command line arguments](http://www.tutorialspoint.com/python/python_command_line_arguments.htm)? – jezrael Jan 30 '16 at 14:01
I think it is for new question. Sorry, I dont know help you. But maybe help this [question](http://stackoverflow.com/questions/1009860/command-line-arguments-in-python) – jezrael Jan 30 '16 at 15:24

append the data in python

1 Answers1