addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Databases (SQL, noSQL); Interfacing R with Excel

  • Dec 14, 2010 · 6:30 PM
  • This location is no longer available

Alert: venue different than usually (see below). In this meeting we'll have 4 short (15-20 min) talks on data storage and processing in databases (both relational and non-relational), interfacing these databases with R, and interfacing R with Excel.
1. A SQL primer for R users Neal Fultz Abstract: At some point, CSVs just don't cut it. In this talk we will introduce database concepts and discuss basic SQL, including conditions, sorting, joins, and aggregation functions, as well as more advanced topics such as subqueries. Bio: Neal is now a PhD student in Statistics at UCLA, after receiving his MIMS from the School of Information at UC Berkeley and working as a Java developer at a marketing analytics startup for several years.
2. R Database Access Shrikrishna Bhogaonker Abstract: I will cover database interfaces to R, such as RODBC, RPGSQL, RMySQL, and some other packages. I will also review the sqldf package, which allows users to search through R dataframes using SQL. Bio: Krishna is a graduate student in Political Science at UCLA. Before that, he spent 10 years managing large networking and hardware deployment projects in the Manufacturing, Chemicals, and Financial Services industries. While at General Motors he played an instrumental role in bringing the company to its knees. While at Bank of America he was almost entirely responsible for the sub-prime lending crisis and the ouster of the CEO.
3. NoSQL data stores Scott Gonyea Abstract: Scott will be introducing some of the concepts behind many NoSQL databases, R packages that are available, etc. Bio: Scott Gonyea is a Ruby software developer at Epoch. He has experience with a variety of SQL and "NoSQL" databases, Search, data processing, etc. Besides Ruby, Scott has worked extensively in Perl, C, ObjC, and Java, among many others.
4. Interfacing R with Excel Eric Kostello Abstract: R and Excel often coexist and people need to exchange data between the two. I will present a table of which solutions can read, which can write, and on which platforms. I will then demonstrate one cross-platform read/write solution: the xlsx package. I will also show a Windows only solution that allows for manual formatting of Excel templates, then programmatic population of the cells and sheets using R and RDCOMClient. I will conclude with a brief discussion of the RExcel package. Bio: Eric Kostello, PhD, is the Director of Product Development in the Global Product Strategy and Integration group of The Nielsen Company. He is currently working with Nielsen/NRG, which specializes in research for movie studios. He has extensive experience working with survey data and has conducted investigations into topics ranging from user generated content metrics to the transition to market economies in Eastern Europe. Please
RSVP as places are limited.
Venue (different than usually!): UCLA MS 6627 (north wing of the same building) Starting time as usual: 6:30pm

Join or login to comment.

  • Scott P.

    thanks. as always, I learned something new. I especially liked the nosql presentation since I didn't know much about it before.

    December 17, 2010

  • Juana S.

    The three talks and Szilard's contextualization of the talks were interesting, useful and comprehensive.

    December 15, 2010

  • A former member
    A former member

    The talks assumed more background than I had. I know how to analyze the data I work with, but I don't really understand how a database is different than a flat file. For example, I don't know what a 'join' operation is. That basic stuff is what I was hoping to get out of this.

    December 15, 2010

  • A former member
    A former member

    It was nice to hear about the different database + interface options. I thought it was very relevant for R users.

    December 15, 2010

  • Yasmin L.

    @michaelSchu...the building is tricky to navigate, you can't get to all parts of bldg from every entrance. Pay attention to which door you are told to enter. Parking is straightforward if pricey. There are metered spots in the lots. I think lot 9 is closest, but lot 6 is also close.

    December 14, 2010

  • A former member
    A former member

    Is anyone interested in carpooling today from the Long Beach/OC area?

    December 14, 2010

25 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy