Restricted Access Period for Mid-term Exams

From 8am to 7pm, Monday to Friday, February 20th through March 9th, Watson Library is open to all current graduate students, undergraduates in economics, faculty, and staff.

At all other times during these two weeks, i.e. after 7pm until close and all open hours on Saturday and Sunday, Watson Library is available to all University affiliates.

If you need materials or services during the 8am to 7pm period designated above and you are not in one of the groups listed please ask a library staff member for help.

Study space is available in Butler Library, Lehman Library (3rd floor of International Affairs Building), and the Science and Engineering Library (campus level of the NorthWest Corner Building).  http://library.columbia.edu/services/study-spaces.html

And check out the designated talk zones now available across the across the Columbia Libraries!  https://blogs.cul.columbia.edu/business/2015/09/01/talk-zones-come-to-columbia-libraries/

If you have any questions, please contact our staff at 212-854-7804 or business_circulation@library.columbia.edu.  Thanks.

ADI Hackathon – February 3rd-4th

The Application Development Initiative Group (ADI) will be hosting a Hackathon in the Watson Library of Business & Economics starting at 4pm this Friday, February 3rd, and ending at Noon on Saturday, February 4th.  During this time, use of the main ground floor reading room and study rooms (G01-G17) will be restricted to use by Hackathon participants.  The rest of the Library (including the computer workstations, 1M & 2M study spaces, and mezzanine study rooms) will remain accessible to all eligible patrons as usual.

To view the hours of operation for Watson Library, please visit this page… https://hours.library.columbia.edu/?library=business

To contact the Watson Library staff, please call 212-854-7804 during our open hours or send an  email to business_circulation@library.columbia.edu.  Thanks.

New Dataset: Infogroup’s Historical Business File

Columbia University has access to the Infogroup’s Historical Business File via WRDS.

Infogroup gathers geographic location-related business and residential data from various public data sources, such as local yellow pages, credit card billing data, etc. The Infogroup database at WRDS contains two packages: Historical Business and Historical Residential, both of which largely focus on US sectors.

The Historical Business data starts in 1997, while Historical Residential dates back to 2006. The Historical Business data is a calendar year-end snapshot of local business data. It contains business identification, location, industry, corporation hierarchy, employment, sales, and other fields.

For more information about this dataset, please visit this page

Figure 1

Table1

Table2

Using Python, R, MATLAB APIs for Datastream!

Do you know that in addition to Excel API, now you can also extract data easily from Datastream by using Python, R, or MATLAB?

For Python:

PyDatastream is a Python interface to the Thomson Dataworks Enterprise (DWE) SOAP API (non free), with some convenience functions for retrieving Datastream data specifically. This package requires valid credentials for this API.

It is a Python API for time-series data which abstracts the database which is used to store the data, providing a powerful and unified API. It provides an easy way to insert time-series datapoints and automatically downsample them into multiple levels of granularity for efficient querying time-series data at various time scales.

 

 

Alternatives for other scientific computing languages:

Please note that only PhD students and faculty can request credentials. Please email business@library.columbia.edu if you had any questions.

Intersession Hours

The Winter Intersession hours for the Watson Library of Business & Economics are as follows…

Friday,12/23                                             8am – 5pm

Saturday,12/24 – Tuesday,12/27           Closed

 

Wednesday, 12/28 – Friday,12/30         8am -5pm

Saturday,12/31 – Tuesday, 1/03            Closed

 

Wednesday, 1/04 – Friday, 1/06            8am -5pm

Saturday, 1/07 – Sunday, 1/08               10am-6pm

 

Monday, 1/09                                           7:30am-9pm

Tuesday, 1/10                                           7:30am-10pm

Wednesday, 1/11                                      7:30am – 7pm

Thursday, 1/12                                         7:30am – 10pm

Friday, 1/13                                              7:30am-7pm

Saturday, 1/14 – Monday, 1/16             Closed

Regular Spring Hours begin Tuesday  1/17/17 and can be found at http://hours.library.columbia.edu/?library=business

Happy Holidays!

 

 

final exams – restricted access period

From 8am to 7pm, Monday to Friday, December 8th through December 22nd, Watson Library is open to all current graduate students, undergraduates in economics, faculty and staff.

At all other times during these two weeks, i.e. after 7pm until close and all open hours on Saturday and Sunday, Watson Library is available to all University affiliates.

If you need materials or services during the 8am to 7pm period designated above and you are not in one of the groups listed please ask a library staff member for help.

Study space is available in Butler Library, Lehman Library (3rd floor of the International Affairs Building), and the Science and Engineering Library (campus level of the NorthWest Corner Building).  A listing of study space open NOW can be found at… http://hours.library.columbia.edu/study-spaces-open-now.php

Thanksgiving – Watson Library closed

Watson Library of Business & Economics will be closing early at 5pm today, and will be completely closed on Thursday 11/24 & Friday 11/25.

The Library will reopen on Saturday 11/26 for the reduced hours of 10am-6pm, and will resume regular hours on Sunday 11/27 by being open from 10am-11pm.

Watson Library’s full schedule of hours can be found at… http://hours.library.columbia.edu/?library=business.  Enjoy the Thanksgiving holiday!

Election Day – Watson Library closed

The Watson Library of Business & Economics and Uris Hall will be closed on Tuesday 11/08 due to Election Day.  Many other libraries on the Morningside campus will be open for regular or reduced hours tomorrow, though.  http://hours.library.columbia.edu/

Avery Architecture & Fine Arts Library  9am-11pm

Barnard College Library  8:45am-Midnight

Burke Library at Union Theological Seminary  9am-10pm

Butler Library Service Hours  9am-11pm  [plus 24-hour reading rooms]

East Asian Library (Starr)  9am-7pm

Lehman Social Sciences Library  9am-5pm

Mathematics Library  9am-5pm

Music & Arts Library (Wiener)  9am-5pm

Science & Engineering Library  9am-5pm

Social Work Library  10am-6pm

Watson Library will resume regular hours starting at 8am on Wednesday 11/09.