title: How do I transpose/pivot a csv file with python *without* loading the whole file into memory?
body: <p>For one of my data analysis pipelines, I end up generating a lot of individual CSV files.  I would like to transpose them, concatenate them, and transpose them again.  However, the amount of data is large, so loading it all into memory is not practical.</p>