[Tutor] Adding Value to CSV

Christian Witts cwitts at compuscan.co.za
Mon Nov 2 11:34:20 CET 2009


Paras K. wrote:
> What I am trying to do is as I am writing the row to the CSV file, I 
> want to add the string base on a few other checks that I still need to 
> write.
>
> Ex.
>
> readline = '"152.88.91.98","BitTorrent Client 
> Activity","1","2009-09-23 15:40:33"\r\n'
>
> At the end of this based on my checks I want to be able to write a 
> string like
>
> Part of DHCP Pool or Part of VPN Pool
>
> So the final line should be something like this written to the CSV file:
>
> '"152.88.91.98","BitTorrent Client Activity","1","2009-09-23 
> 15:40:33", "Part of DHCP Pool"
>
> Thanx in advance for the help.
>
> On Sun, Nov 1, 2009 at 7:16 AM, Dave Angel <davea at ieee.org 
> <mailto:davea at ieee.org>> wrote:
>
>     Paras K. wrote:
>
>         I have some code that is going through a number of test.
>
>         When I have the line that has been read I need to add another
>         value at the
>         end of it, or write the information into another csv file
>
>         Example of my code:
>
>         for line in fh.readlines():
>                    readline = line
>                    ipline = readline
>                    ip = ipline.split(' ')[0]
>                    split_ip = ip.split('.')
>                    if ((split_ip[0] == '"152')):
>                        ff.write(readline)
>                        totalcount +=1
>
>
>         I need to add another piece, how can I add another field at
>         the end of
>         ff.write(readline)
>
>
>         Any assistance would be greatly appreciated. Thank You.
>
>          
>
>     If your program is correct so far, then you could add it simply with:
>                ff.write(readline + " " + newdata)
>
>     Although your message subject says CSV, it looks like you're
>     breaking the line up by spaces.  So if in fact each field is
>     constrained not to have a space within, and there is a single
>     space between fields, then the above will work.
>
>     If, on the other hand, you have to deal with fields that can
>     contain the delimiter, perhaps escaped or quoted, then things get
>     much more complicated.
>
>     DaveA
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>   
Use .strip() to remove the end-of-line characters and then add the 
string you want to the end of the line including end-of-line character.

-- 
Kind Regards,
Christian Witts




More information about the Tutor mailing list