Data Science I: Essential Tools - Washington DC

10 Sep. 2019 09:00 - 12 Sep. 2019 16:30
Business & Career
Science and technology


Answer complicated questions, uncover greater insights and learn high-demand skills with Python and the power of data science. This 3-day course provides the foundational knowledge needed to move beyond the limitations of traditional spreadsheets to streamline and automate time-consuming tasks and encourage data-driven decision making.

Day 1: The  Essentials of Python for Data Science:

  • Construct variables in Python and understand commonly used data structures

  • Perform iterations in Python to easily apply a process over multiple values

  • Encapsulate a process into a function to streamline and reduce repetition

  • Utilize if/else statements to handle various cases and conditions

  • Understand string data types and common operations applied to strings

Day 2: Object-Oriented Programming (OOP) and NumPy and Pandas Python packages:

  • Understand how OOP is implemented and used throughout Python and its packages

  • Use NumPy ndarray data structures for fast, multidimensional numerical operations

  • Utilize Pandas’ data structures and load CSV and Excel files as Pandas dataframes

  • Combine tables across multiple spreadsheets into one dataframe

  • Handle missing entries/data with Pandas, and utilize methods to replace missing values

Day 3: Advanced Panda Techniques and Task Automation

  • Use grouping operations in Pandas to create groups within a dataframe

  • Use NumPy functions in Pandas and understand the connection between them

  • Utilize manipulation and analysis tools in Pandas for times series

  • Up and down sample time series to change frequency

  • Understand time series transformations

  • Visualize data analysis results using

    • Matplotlib to create line and scatter plots, histograms and bar charts

    • Seaborn package to generate statistically focused plots



Daily Schedule

8:30 - 9:00 a.m.Registration and Breakfast

9:00 - 12:00 p.m.Course & Lab Work

12:00 - 1:00 p.m.Buffet Lunch*

1:00 - 4:30 p.m.Course & Lab Work


Two 15 minute breaks will be given at 10:30 a.m. and 2:30 p.m.

Travel: There is a group rate of $139 per night held at the Executive Conference & Training Center. Please click here or call 703-708-0808 and mention Pragmatic Institute before the cut off date of August 11, 2019. If the reservation cut off date has passed please contact Samantha Aguilar at 480-776-1905 or at Room blocks are limited and sell out. Complimentary Wi-Fi in the meeting room.

Breakfast and lunch buffets are provided daily, along with refreshments during breaks. We make an effort to provide a variety of well-rounded offerings. However, if you have a specific dietary requirement, please bring it to our attention during the checkout process so that it can be accommodated.


Attire: Casual. Please bring a sweater or jacket in case the temperature in the meeting room gets cold.


Fees: Your course fee includes a complete set of training materials, certification test, breakfast, and lunch. Note: all fees are USD.


ADA: Please let us know how we can help you fully participate in the meeting at +1-480-515-1411 or email us.