intermediate python csv reader/writer question from a beginner

Discussion in 'Python' started by Learning Python, Feb 23, 2009.

  1. anything related to csv, I usually use VB within excel to manipulate
    the data, nonetheless, i finally got the courage to take a dive into
    python. i have viewed a lot of googled csv tutorials, but none of
    them address everything i need. Nonetheless, I was wondering if
    someone can help me manipulate the sample csv (sample.csv) I have

    1,Adam,1,2,Monday,1:00 PM,,
    2,Bob,3,4,Monday,1:00 PM,,
    3,Charlie,5,6,Monday,1:00 PM,,
    4,Adam,7,8,Monday,2:00 PM,,
    5,Bob,9,10,Monday,2:00 PM,,
    6,Charlie,11,12,Monday,2:00 PM,,
    7,Adam,13,14,Tuesday,1:00 PM,,
    8,Bob,15,16,Tuesday,1:00 PM,,
    9,Charlie,17,18,Tuesday,1:00 PM,,

    into (newfile.csv):

    1,2,3,4,5,6,Monday,1:00 PM
    7,8,9,10,11,12,Monday,2:00 PM
    13,14,15,16,17,18,Tuesday,1:00 PM

    1. the true header doesn't start line 4 (if this is the case would i
    have to use "split"?)
    2. if there were SEQ#10-12, or 13-15, it would still be Adam, Bob,
    Charlie, but with different Test1/Test2/Date/Time
    Learning Python, Feb 23, 2009
    1. Advertisements

  2. Learning Python

    Chris Rebert Guest

    For reading and writing CSV files, see the `csv` module in the
    standard library (

    Chris Rebert, Feb 24, 2009
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.