So if my long row is row two...how do I tell it to use row 2? On Thu, Mar 20, 2008 at 5:42 PM, Kent Johnson <[EMAIL PROTECTED]> wrote:
> Spencer Parker wrote: > > I am trying to read a CSV file and the get that information into a MySQL > > database. I am able to do this, but I have a small problem. I have a > > piece of software that runs and each iteration is one like. It only > > runs once right now; there is only one line + the headers. I use the > > csv module to kill the headers and import the one line. The problem > > is...I need to have it split the csv file at some point. I need to first > > 20 items taken off and then have the next 7 + the first 20 imported into > > the database...then have it do this for the next 7 + the first 20...so > > on and so forth until hits the end of the line. > > I'm not sure I understand. It sounds like you have a very long line of > data from the csv file and you want to split it into groups of 7, after > taking the first 20 items. If that is correct, something like this might > work: > > row = ... # your long row > prefix = row[:20] # the twenty items that repeat > for i in range(20, len(row), 7): > next = prefix + row[i:i+7] > # Handle 'next' - add it to the database or whateve > > Kent > -- Spencer Parker _______________________________________________________ "if you can't go to heaven, may you at least die in Ireland." _______________________________________________________
_______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
