How to extract a single datapoint from multiple CSV files to a new file : I have hundreds of CSV files on my disk, and one file added daily and I want to extract one data point (value) from each of them and put them in a new file. Then I want to daily add values to that same file. CSV files looks like this:

    business_day,commodity,total,delivery,total_lots
    .
    .
    20160831,CTC,,201710,10
    20160831,CTC,,201711,10
    20160831,CTC,,201712,10
    20160831,CTC,Total,,385
    20160831,HTC,,201701,30
    20160831,HTC,,201702,30
    .
    .

I want to fetch the row that contains 'Total' from each file. The new file should look like:

    business_day,commodity,total,total_lots
    20160831,CTC,Total,385
    20160901,CTC,Total,555
    .
    .

The raw files on my disk are named '20160831_foo.CSV', '20160901_foo.CSV etc..

After Googling this I have yet not seen any examples on how to extract only one value from a CSV file. Any hints/help much appreciated. Happy to use pandas if that makes life easier. 