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.08 Python 3.1 Modules

Collection home page

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

These are a tidier, better documented, repackagings and extensions of the 'sheetexpand1gen' and 'sheetutility' Python 2.5.2 modules. Always open Python modules with a text editor to look for advice before using. More recent modules, available from the author, were used to extract counts of nests (nests with at least one egg or provisioned cell), eggs, harvested immatures, or emerged adults by species and cavity width for the population study of 11.09.

'Utility.py' contains widely applicable editing functions, e.g., the function 'Utility.unfoldsource' reformats a SOURCE spreadsheet (1 row per cavity) into a sheet with one row for each species within each cavity --a long page or 'longp' file. The 'longp' example in this collection is the unfolded version of the SOURCE.ods and SOURCE.csv files in 04.05. As there can be upto 5 bee or wasp species in a cavity during the season the 'longp' version is upto 5 times as long as the usual sheet. Because few cavities have more than 2-3 species most of the later rows in a 'longp' file are redundant (which should be remembered when making simple spreadsheet sums).

Recent Submissions

A longp file ('long page') is comparable to a SOURCE file but perhaps 4 times longer. Now each species in the cavity has its own row. and redundant rows are numerous because many cavities have 0 or 1 nests.

In a SOURCE file each non-redundant row is a cavity with a set of columns for each species in the cavity. (Redundant rows are stack titles, etc).


Population data: counts of nests (at least 1 egg in sealed provisioned cell), eggs, harvested immatures or emerged adults or eggs, by species group AND cavity width.



  View all ...


RSS Feeds

RSS Feed
RSS Feed
RSS Feed