test Browse by Author Names Browse by Titles of Works Browse by Subjects of Works Browse by Issue Dates of Works

Advanced Search
& Collections
Issue Date   
Sign on to:   
Receive email
My Account
authorized users
Edit Profile   
About T-Space   

T-Space at The University of Toronto Libraries >
P. E. Hallett (2011) Farmed Solitary Bees & Wasps, Data Set (generations 1997-2008) >
04.0 Data coding >

04.09 For programmers

Collection home page

or browse 
Subscribe to this collection to receive daily e-mail notification of new additions

This collection contains most of the tools that programmers may need.

Note that column W in the 'SOURCE' files is not quite fully expanded.

Examples: (i) the dated events or dot segments of regular records (e.g. the '.fn060625x060731' in ')olA_db.fn060625x060731&5-MI5%0#:' ; (ii) the 'egg harvest' versions of special record segments, e.g. the '&8' in '|olA_db.n060618&8#:'; (iii) the loss '-MI5' above which is both a cause of deaths (MI = mites) and its magnitude (5 immatures).

The 'dotSOURCE' spreadsheets of 04.10 and 11.06 are a tentative response to (i). Probably all of (i) to (iii) need resolution before (say) PostgreSQL data basing. For year-by-year analyses, going from 'SOURCE' via Python to a special output file, like those filed under 'COUNT', is quite adequate. Data basing would offer the additional possibility of following particular nest blocks across years.

The files '04a. Data coding' and '04b. Worked examples' are intended for anyone who uses the SOURCE spreadsheets, whether programmer or not. (a) A quick understanding of column W coding saves having to read very long spreadsheet lines; (b) column W can be filtered with simple spreadsheet formulas like 'countif' for quick explorations; (c) accidentally introduced white space or missing colons in column W block Python expansion of the record ---but the missing expansion can often be quickly inserted by hand because of the redundancy in the code.

Recent Submissions


04d_The_action_columns_K_and_V_and _a note_about_Osmia_texana.


04b. Worked examples.

04a. Data coding.


  View all ...


RSS Feeds

RSS Feed
RSS Feed
RSS Feed