My Cart 0 items

Based on Your overwhelmed Response GlobalCompliancePanel is Back with 50% Discount on all Seminars

Use GCPCN50 Promo Code to Get Flat 50% OFF - OFFER ENDS TODAY

2-day In-person Seminar

Performing Data Analysis with Multiple Tools: Pandas, R and Deedle (F#/C#)


January 14th & 15th, 2016

Time: 9:00 AM to 6:00 PM

SFO, CA

Venue: DoubleTree by Hilton Hotel San Francisco Airport


Director : Michael Heydt
  Price: $1,495.00
(Seminar Fee for One Delegate)


**Please note the registration will be closed 2 days (48 Hours) prior to the date of the seminar.

The seminar will begin with an over view of data science and many the steps required for collecting, cleaning, organizing and deriving information out of data. The steps are common to all of the tools and will form the foundation for analyzing, comparing and utilizing the tools used in the remainder of the seminar: R, pandas and Deedle.

Topics covered in the foundation are:
  • Organizing information into data frames
  • Mutating data frame objects
  • Indexing data frames
  • Data alignment between data frames
  • Handling missing data
  • Joining data
  • Reading and writing data from files and databases
  • Accessing data from web services
  • Reshaping of data (ie: pivoting and melting)
  • Slicing and subsetting data
  • Grouping of data
  • Deriving aggregate results from data
  • Handling of time series information
  • Resampling time series data into other frequencies
  • Shifting time series data
  • Moving and sliding windows statistics
  • Data visualization

This seminar will then proceed into demonstrations and hands on experience using R Studio, pandas in Enthought Canopy, and Deedle in Visual Studio. Each of the topics covered in the data science overview will be demonstrated with each tool, including hands on installation and experimentation through several exercises. By the end of these three sessions (R, pandas and Deedle) the participant will be able to create their own data science environments in any of the tools and have the knowledge of how to proceed with performing the core concepts in each environment, as well as be able to determine which tools are best for their needs.


Why should you attend:

Data Science is becoming the must-have skill in technology and business. But do you know what it is, why it is important, and how it differs from business intelligence and big data? Do you know that there are very useful open source tools on multiple platforms that allow you to perform data science? That you can leverage your existing Python or .NET programming skills, or use other domain specific languages such as R?

Data science is deep knowledge discovery through the interactive exploration of data. This discipline often involves using mathematic and algorithmic techniques to solve some of the most analytically complex business problems, leveraging troves of raw information to figure out hidden insight that lies beneath the surface. It centers on evidence-based analytical rigor and building robust decision capabilities.

Data science matters because it enables companies to operate and strategize more intelligently. It is all about adding substantial enterprise value by learning from data.

Most who start to learn Data Science turn to domain specific languages such as R. If you know even a little about Python, there is a well-established Python library "pandas": The Python Data Analysis Library. And on the .NET platform, there is the open source Deedle library for exploratory data analysis in F# and C#, which was created by quants at BlueMountain Capital.


Areas Covered in the Session:

General concepts in data sciences
  • Data frames
  • Time series
  • Data alignment
  • Data mutation
  • Indexing
  • Joins
  • Slicing
  • Local and web data access
  • Time series manipulation
  • Grouping and aggregation
  • Handling missing data
  • Statistical analysis
  • Moving and sliding windows
  • Visualization

Who Will Benefit:

  • Data Analysts Wanting to Learn any of the Covered Tools
  • IT VP and Development Managers
  • Application / Software Architects
  • Application / Software Developers and Engineers
  • Individuals or organizations interested in data science and how to derive meaning from data

Day 1 Schedule


Lecture 1:

A Survey of data science and tools tools

  • R, Pandas and Deedle

Lecture 2:

General concepts in data sciences

  • Data frames
  • Time series
  • Data alignment
  • Data mutation
  • Indexing
  • Joins
  • Slicing
  • Local and web data access
  • Time series manipulation
  • Grouping and aggregation
  • Handling missing data
  • Statistical analysis
  • Moving and sliding windows
  • Visualization

Lecture 3:

Pandas for data science

  • Data frames
  • Time series
  • Data alignment
  • Data mutation
  • Indexing
  • Joins
  • Slicing
  • Local and web data access
  • Time series manipulation
  • Grouping and aggregation
  • Handling missing data
  • Statistical analysis
  • Moving and sliding windows
  • Visualization
  • Exercises

Day 2 Schedule


Lecture 4:

R for data science

  • Installing R and R Studio
  • Data frames
  • Time series
  • Data alignment
  • Data mutation
  • Indexing
  • Joins
  • Slicing
  • Local and web data access
  • Time series manipulation
  • Grouping and aggregation
  • Handling missing data
  • Statistical analysis
  • Moving and sliding windows
  • Visualization
  • Exercises

Lecture 5:

Data sciences with Deedle

  • Installation
  • Data frames
  • Time series
  • Data alignment
  • Data mutation
  • Indexing
  • Joins
  • Slicing
  • Local and web data access
  • Time series manipulation
  • Grouping and aggregation
  • Handling missing data
  • Statistical analysis
  • Moving and sliding windows
  • Visualization
  • Exercises
Want to register by P.O/Check?
We facilitate registration by P.O/Checks!
Complete your registration in just a few easy steps
Please just download, fill out the registration form and send it to us either by email to support@globalcompliancepanel.com or just fax us at 302 288 6884.
Once the form is received, an invoice will be generated and sent back to your fax number.
Following this just send us your purchase order by fax at 302 288 6884
Click here to download Registration form
In case you wish to register by using check
In case you wish to register by using check, please make a check to NetZealous LLC DBA GlobalCompliancePanel.com and mail it to the below address.
NetZealous LLC,
DBA GlobalCompliancePanel,
161 Mission Falls Lane,
Suite 216, Fremont, CA 94539, USA
Phone: 1800 447 9407

Want to register by Wire Transfer?
Please call any of our representatives on 1800 447 9407 to help you completed the transfer.
Group participations
Get fabulous discounts by participating in groups of two or more.
No Attendees Discount
1 2 Attendees 10% off
2 3 to 6 Attendees 20% off
3 7 to 10 Attendees 25% off
4 10+ Attendees 30% off

To avail the above group discounts, all the participants should register by making a single payment

Call our representative TODAY on 1800 447 9407 to have your seats confirmed!

Michael Heydt

Principal Technology Manager, SunGard Global Services

Michael Heydt is an independent consultant, educator and trainer with nearly thirty 30 years of professional software development experience, during which time he has focused on agile software design and implementation using advanced technologies in multiple verticals including media, finance, energy and healthcare. He holds a MS in Mathematics and Computer Science from Drexel University, and a Masters of Technology Management from the University of Pennsylvania School of Engineering and Wharton Business School.

His studies have focused on technology management, software engineering, entrepreneurship, information retrieval, data sciences, and computational finance. Since 2005 he has specialized in building energy and financial trading systems for major investment banks on Wall Street and several global energy trading companies, utilizing .NET, C#, WPF, TPL, DataFlow, Python, R, Mono, iOS, Android, and many others tools too numerous to list.

His current interests are creating seamless applications using desktop, mobile and wearable technologies, and which utilize high concurrency, high availability, real-time data analytics, augmented and virtual reality, cloud services, messaging, computer vision, natural user interfaces, and software defined networks. He is the author of numerous technology articles, papers and books, is a common speaker at .NET users groups and various mobile and cloud conferences, and regularly delivers webinars on advanced technologies.

Location: SFO, CA Hotel: DoubleTree by Hilton Hotel San Francisco Airport   835 Airport Blvd., Burlingame CA 94010-9949

Copyright © 2016 GlobalCompliancePanel. All rights reserved. Netzealous