[Tutor] data from excel spreadsheet to csv and manipulate

Shawn Milochik Shawn at Milochik.com
Wed Oct 3 16:03:36 CEST 2007


On 10/3/07, sacha rook <sacharook at hotmail.co.uk> wrote:
>
> Hi
>
>  can anyone help with the best way to tackle this?
>
>  I have a spreadsheet ms excel, that has a name column that I want to
> extract to csv and manipulate as follows.
>
>  The name column has data in this format
>
>  Name
>
>  Surname Firstname
>
>  after extracting and manipulating I want it to be as follows in three comma
> separated fields;
>
>
>  Firstname, Surname, Firstname Surname
>
>  So
>
>  Smith John
>
>  becomes
>
>  John, Smith, John Smith
>
>  I hope I have explained myself.
>
>  I want to use python to do all this if sensible, so what is the best
> approach?
>
>  Many thanks
>
>  S
>
> ________________________________
> Do you know a place like the back of your hand? Share local knowledge with
> BackOfMyHand.com
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>


Here's the best approach:

1. Browse: http://python.org/doc/

2. Search Google.

3. Write code.

4. Post code to the group and ask for help with the pieces that aren't
working as you expect.

Have fun!

Shawn



More information about the Python-list mailing list