Python

Python for Data Sciences Training

Python for Data Sciences

In this course you will learn to use Python, the most popular programming language for data sciences, for data analysis and data visualization. Explore Python libraries to more easily sort and analyze data sets for emerging trends. Quickly produce Excel quality visualizations appropriate for displaying data in real time monitoring systems.

Training at a glance

Level

Beginner

Duration

5 Days

Experience

1 year: Python

Average Salary

$141,658

Labs

Yes

Level

Beginner

Duration

5 Days

Experience

1 year: Python

Average Salary

$141,658

Labs

Yes

Training Details

Intro to data science using Python libraries like pandas and numpy to identify trends within datasets. Create rich visualizations with matplotlib, folium and seaborn. Use open source toolset scipy for mathematics, science, and engineering applications. Introduction to scikit-learn, a machine learning tool for datasets.

Lesson 1: Introduction to Python Libraries for Data Sciences

  • Python with Jupyter Notebook overview
    • Live code
    • Equations
    • Data cleaning
    • Transformation
    • Numerical simulation
    • Statistical modeling
    • Data visualization
    • Machine Learning
  • Pandas
    • Filter DataFrames
    • Dictionaries to DataFrames
    • CSV to DataFrames
    • Excel to DataFrames
  • Numpy
    • Work across arrays
  • Requests
    • Pull from RESTful APIs
    • JSON

 

Lesson 2: Sort, Analyze, and Visualize Data with Python

  • Matplotlib
    • Line Plots
    • Area Plots
    • Histograms
    • Bar Charts
    • Pie Charts
    • Box Plots
    • Scatter Plots
    • Bubble Plots
    • Waffle Charts
    • Word Clouds
  • Seaborn
    • visualization techniques
      1. Relational
      2. Categorical
      3. Distributions
      4. Regressions
  • Folium
    • interactive leaflet maps
    • rich vector/raster/HTML visual markers
  • Saving visualizations output in various formats

 

Lesson 3: Python and Databases

  • Creating a database engine in Python
  • sqlite3
  • Looking at tables in a database
  • Querying relational databases
  • MySQL and Python
  • SQL Queries
    • Filtering with SQL WHERE
    • Ordering with SQL ORDER BY
    • Querying with pandas
    • Table relationships with INNER JOIN
  • MongoDB
    • Understanding noSQL
    • Python and MongoDB
    • Pymongo
      1. Query
      2. Find
      3. Delete
      4. Update
      5. Limit

 

Lesson 4: Introduction to Machine Learning with Python

  • scipy open ecosystem
    • numerical integration
    • Optimization
    • linear algebra
    • statistics
  • Scikit-learn
    • Applications of Machine Learning
    • Training vs Testing sets
    • Supervised vs Unsupervised Learning
    • Python libraries suitable for Machine Learning
    • Loading an example dataset
    • Learning and predicting

 

Lesson 5: Introduction to Machine Learning with Python (continued)

  • Scikit-learn
    • Model persistence
    • Conventions
    • Refitting and updating parameters
    • Multiclass vs. multilabel fitting
  • Moving output to remote systems
    • Streaming (push) to real-time dashboard APIs
    • Move data with SFTP

 

Labs

  • Lab 01 – Using vim
  • Lab 02 – Making and Syncing a Github account
  • Lab 03 – Using Jupyter Notebook
  • Lab 04 – Working with Local FIles
  • Lab 04 – Pandas DataFrames
  • Lab 05 – CSV to DataFrames
  • Lab 06 – Excel to DataFrames
  • Lab 06 – Numpy Array
  • Lab 07 – Requests and APIs
  • Lab 08 – Getting JSON from RESTful APIs
  • Lab 09 – Matplotlib and Line Plots
  • Lab 10 – Matplotlib and Histograms
  • Lab 11 – Matplotlib and Pie Charts
  • Lab 12 – Matplotlib and Scatter Plots
  • Lab 13 – Matplotlib and Bubble Plots
  • Lab 14 – Matplotlib and Bar Charts
  • Lab 15 – Seaborn and Relational Visualizations
  • Lab 16 – Seaborn and Categorical Visualizations
  • Lab 17 – Seaborn and Distributions
  • Lab 18 – Seaborn and Regression Models
  • Lab 19 – Folium and Leaflet Maps
  • Lab 20 – Filtering SQL
  • Lab 21 – Ordering SQL
  • Lab 22 – Querying SQL with Pandas
  • Lab 23 – Querying MongoDB with pymongo
  • Lab 24 – Pymongo Find, Delete, Update, Limit
  • Lab 25 – Scipy and numerical integration
  • Lab 26 – Scipy and linear algebra
  • Lab 27 – Scipy and statistics
  • Lab 28 – Scikit-learn and machine learning
  • Lab 29 – Training vs Testing sets
  • Lab 30 – Scikitlearn and supervised learning
  • Lab 31 – Scikitlearn and unsupervised learning
  • Lab 32 – Pushing data to real time dashboard APIs
  • Lab 33 – Moving data with SFTP
  • Lab 34 – Emailing with Attachments

This course was written for professionals interested in Python and Data Sciences.

This includes: 

  • Engineers,
  • Mathematicians,
  • Actuaries,
  • Network Specialists,
  • System Admins, and developers.

Keyboard proficiency, and some previous python coding experience is the only hard requirement. Students with some previous exposure to Python, or any another scripting experience, will take the most from the course. In lieu of previous experience, Alta3 research’s Python Basics course is recommended. 
Recommended Prerequisite: Python Basics (5 days)

Upcoming Classes

We Offer More Than Just Python Training

Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.

Strategic Planning & Project Management

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.

IT & Cybersecurity

ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.

Leadership & Management

Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.