Eric,

We do something similar to Ken from our iii catalogue, to produce our top 10 lists

http://www.bury.gov.uk/index.aspx?articleid=6311

Though this is based on a monthly marc extract of the entire catalogue and then loaded into a database, which we also use to help with weeding promotion etc (though there is no web front end at the moment).

There are a number of commercial products that do this as well.

regards

Alan


Alan Brown
Libraries System Liaison Officer
Bury Libraries
Resource Services
Textile Hall
Manchester Rd
BL9 0DG
http://www.bury.gov.uk/libraries
http://library.bury.gov.uk





-----Original Message-----
From: Ken Irwin [mailto:[log in to unmask]] 
Sent: 14 January 2015 01:12
Subject: Re: circulation statistics

Eric,

It's not Aleph, but... III's catalog has a "create list" function that lets you create a list of records (bib records, item records, patron records, etc) that meet certain criteria (patrons who live is xxxxx zip code, items in the main stacks with more than 5 checkouts, etc.) 

To do what your friend is trying to do, it would help to have some way of flagging the relevant records (popular lit) -- maybe they are the books in a particular location, or maybe he's added a local subject heading, etc -- something that lets him point to a particular subset of the collection. So his process might look something like:
* find all the books that match:
 - published since 1980
 - location = popular fiction collection
 - total circ > 2
* and then export selected fields:
 - author
 - title
 - publisher
 - year
 - total circs
 - total renews

Or something like that. 
This is exactly the kind of search and extraction that I designed my Weeding Helper tool to work with -- only there I'm looking at *un*-popular materials: 
https://github.com/kenirwin/Weeding-Helper 
Demo: http://www6.wittenberg.edu/lib/iii/weed/demo/view.php?table=art_orders 
It takes that sort of search-and-export data from the catalog and makes it sortable and subject to note-taking so you can take a computer or tablet up to the stacks and weed a range of books and have their circ history in front of you. 

Ken

-----Original Message-----
From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of Eric Lease Morgan
Sent: Tuesday, January 13, 2015 5:08 PM
To: [log in to unmask]
Subject: [CODE4LIB] circulation statistics

Does anybody here know how to extract circulation statistics from an library catalog? Specifically, given a date range, are you able to create a list of the most frequently borrowed books ordered by the number of times they’ve been circulated?

I have a colleague who wants to digitize sets of modern literature and then do text analysis against the result. In an effort to do the analysis against popular literature, he wants to create a list of… popular titles. Getting a list of such a thing from library circulation statistics sounds like a logical option to me. 

Does somebody here know how to do this? If you know how to do it against Ex Libris’s Aleph, then that is a bonus. 

—
Eric Morgan
-----------------------------------------------------------------
Why not visit our website www.bury.gov.uk
-----------------------------------------------------------------
Incoming and outgoing e-mail messages are routinely monitored for compliance
with our information security policy.
The information contained in this e-mail and any files transmitted
with it is for the intended recipient(s) alone. It may contain
confidential information that is exempt from the disclosure under
English law and may also be covered by legal,professional or other privilege.
If you are not the intended recipient, you must not copy, distribute or take any
action in reliance on it. 
If you have received this e-mail in error, please notify us immediately by using 
the reply facility on your e-mail system.
If this message is being transmitted over the Internet, be aware that it may be 
intercepted by third parties.
As a public body, the Council may be required to disclose this e-mail or any 
response to it under the Freedom of Information Act 2000 unless the information
in it is covered by one of the exemptions in the Act.  
Electronic service accepted only at [log in to unmask] and on fax number 
0161 253 5119 .
*************************************************************