Pandas usecols question

[rsearing]

I am very new to Python (just installed yday) and am workink with Pandas, obviously, also new. I have a large csv file I am trying to read and then send to a MySQL database. The problem is, the file contains some header information and I need to pull in the table inside the data…say, data starting at row 40 (I believe I can handle this with the skiprows property. I also need to grab, say…columns 9-80. I know there’s the usecols property, but I’m only seeing it used where you specify the name of the column. Questions

1) is there any way to specify a range?
2) I haven’t researched this yet, but could you please refer me to what to look up to xfer the data to MySQL please?

Thank you!

[jefsummers]

Clearly you are experienced, so will simply refer you -
iloc is the function you want to specify a range
to_sql is the function to write to a SQL database.

Check the docs for those functions.