Skip to content

Instantly share code, notes, and snippets.

@rufuspollock

rufuspollock/london-spend-csvs-grepping-for-headings.txt

Last active December 19, 2015 10:29
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rufuspollock/5941049 to your computer and use it in GitHub Desktop.
Save rufuspollock/5941049 to your computer and use it in GitHub Desktop.
Download ZIP
Analysis of where the "header" rows actually appears in GLA spend data CSVs. Result of running this script https://github.com/rgrp/dataset-gla/blob/master/scripts/headings.sh. For details of files see https://github.com/rgrp/dataset-gla/blob/master/scrape.json
Raw
london-spend-csvs-grepping-for-headings.txt
2010-11-P01.csv:4:Vendor,Expense Description,Amount,Doc No,,,^M
2010-11-P02.csv:6:Vendor,Expense Description,Amount,Doc No,,,^M
2010-11-P03.csv:6:Document No","Amount
2010-11-P04-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P05-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P06-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P07-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P08-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P09-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P10-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P11-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2010-11-P12-500.csv:7:Vendor ID,Vendor Name ,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2010-11-P13-500.csv:7:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M
2011-12-P11-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2011-12-P12-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2011-12-P13-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2011-12-P1-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,^M
2011-12-P2-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2011-12-P3-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2011-12-P4-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2011-12-P5-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2011-12-P6-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2011-12-P7-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,^M
2011-12-P8-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P10-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2012-13-P11-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2012-13-P12-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2012-13-P13-250.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,^M
2012-13-P1-500.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P2-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P3-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P4-250.csv:878:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P4-250.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P5-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
2012-13-P6-250.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P7-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
2012-13-P9-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
april_2008.csv:3:,Supplier,Expense Description,Amount,,^M
april_2009.csv:3:Supplier,Expense Description,Amount^M
august_2008.csv:4:,Supplier,Expense Description,Amount^M
august_2008.csv:7:,Supplier Name,Expense Code Description,Amount Paid^M
august_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M
december_2008.csv:4:,Supplier,Expense Description,Amount,^M
december_2009.csv:4:Supplier,Expense Description,Amount^M
december_2009.csv:6:Supplier Name,Expense Code Description,Amount Paid^M
february_2009.csv:4:,Supplier,Expense Description,Amount,,,,,^M
january_2009.csv:4:,Supplier,Expense Description,Amount,,,,,^M
january_2010.csv:3:,,Supplier,Expense Description,Amount,Doc Type,Doc No,Date,^M
july_2008.csv:4:,Supplier,Expense Description,Amount^M
july_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,,^M
june_2008.csv:4:,Supplier,Expense Description,Amount^M
june_2009.csv:4:Supplier,Expense Description,Amount,,,,^M
march_2009.csv:3:Supplier,Expense Description,Amount^M
may_2008.csv:4:,Supplier,Expense Description,Amount^M
may_2009.csv:3:,Supplier,Expense Description,Amount^M
Mayor%27s%20250%20Report%20-%202013-14%20-%20P1%20%20-%20Combined.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,^M
Mayors500Report-2011-12-P10-Final.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M
Mayors-500-report2011-12-P9.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M
november_2008.csv:4:,Supplier,Expense Description,Amount,,,,,,^M
november_2008.csv:6:,Supplier Name,Expense Code Description,Amount Paid,,,,,,^M
november_2009.csv:3:Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M
october_2008.csv:3:,Supplier,Expense Description,Amount^M
october_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M
P12- 2009_10_FINAL.csv:4:Vendor,Expense Description,Amount,,,^M
P13-2009-10.csv:4:Vendor,Expense Description,Amount^M
september_2008.csv:4:,Supplier,Expense Description,Amount^M
september_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M
# Not found
2012-13-P8-250.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment