[Tutor] data from excel spreadsheet to csv and manipulate

[Shawn Milochik]

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