Data Handling in Python | QA

Latest events & webinars Reports News Close Search Search Basket 0 Contact us Log in My account toggle menu Close Instructor-led Learning (MyQA) Log in to Self-paced Learning (Cloud Academy) Call 0113 382 6276 Contact Us

Let’s make it work for you

Talk to us top_site Home Browse AI Data Handling in Python (QADHPYTHON) Share Email Download LinkedIn Facebook Twitter QA authored course Data Handling in Python Artificial Intelligence Software and DevOps Virtual from £2,925 +VAT Virtual Virtual Live training via web conferencing Classroom Hands-on training in a QA learning centre Online Self-paced online learning modules and videos Blended Learning Experience QA's most effective way to learn, combining digital and live learning

From £2,925 + VAT

Duration: 3 Days Level:Intermediate Code:QADHPYTHON Tech type: PerformancePlus Tech types
Our courses are labelled to help you choose the right level for your needs. Performance Plus
QA's performance plus courses are often exclusive to QA, these courses harness our expertise to ensure training with real-world application. Exam: Not Applicable Interested in this course? Check out when this course is running and get in touch See available dates Overview

This three day course is aimed at those wishing to learn how to use Python to work with and handle Data. When combined with our Introduction to Data Science course you would be set up well to follow a Python learning journey into Data Engineering, Advanced Data Analytics, Data Science, Machine Learning, and Artificial Intelligence.

During the programme you will be introduced to Python and specific development environments and packages for working with Data, with a focus on NumPy, Pandas, Matplotlib, and Seaborn.

Along the way you will see how to clean and manipulate tabular data, apply simple statistical techniques and data visualisations, and learn about how to control the flow of your program in order to automate processes.

Throughout the course you will engage with activities and discussions with one of our Data Science technical specialists and complete technical lab activities to practice the techniques you have learnt and develop ideas for further practice.

Read more + Prerequisites

No prior experience with Python is necessary, though it is assumed that you will be familiar with core data concepts such as simple table structures and data types – all the pre-requisites you need are covered by our Data Essentials course.

Target Audience

This course is intended for Data Analysts, Data Engineers, Data Ops roles, and those training to consume AI Services or become Data Scientists and tune and develop Machine Learning and AI models on our subsequent Data Science learning pathway.

This course covers the key pre-requisites for a large range of further learning opportunities involving Python, Data, and AI.

Read more + Delegates will learn how to Benefit from the speed and functionality of the NumPy and Pandas python packages Create and control Data Visualisations using Matplotlib and Seaborn Use Python with the Jupyter development environment Retrieve, clean, and prepare data from multiple types of sources Gain a firm grounding in Python with Data in order to progress to further study to connect to AI models, Engineer data pipelines, and develop Data Science solutions Read more + Outline

1. Introduction to Programming for Data Handling

Describe the pros and cons of using programming languages to work with data Identify the languages most suitable for data handling Explain the challenges of using programming languages versus data analysis tools

2. Introduction to Python and IDEs

Describe the key attributes of the Python programming language. Explain the role of the Jupyter IDE for Python programming. Use the Jupyter IDE to write a basic Python program. Write a program which uses string, integer, float and boolean data types.

3. Data Structures, Flow Control, Functions, and Basic Types

Construct collections to solve data problems. Utilise selection and iteration syntax to control the flow of a Python program. Write reusable functions which can be used to alter data & automate repetitive tasks. Use Python's built-in open function to create, read, and edit files.

4. Mathematical and Statistical Programming with NumPy

Describe the core features of NumPy arrays. Create, index, and manipulate NumPy arrays to solve data problems. Use masking and querying syntax to retrieve desired values. Use vectorised ufuncs.

5. Introduction to Pandas

Create, manipulate, and alter Series and DataFrames with Pandas. Define and change the indices of Series & Dataframes. Use Pandas' functions and methods to change column types, compute summary statistics and aggregate data. Read, manipulate, and write data from csv, xlsx, json and other structured file formats.

6. Data Cleaning with Pandas

Identify missing data and apply techniques to deal with it. Deduplicate, transform and replace values. Use DataFrame string methods to manipulate text data. Write regular expressions which munge text data.

7. Data Manipulation with Pandas

Construct Pivot tables in Pandas. Time series manipulation. Stream data into Pandas to handle data size problems.

8. Methods for Visualising Data

Construct and tailor basic data visualisations using Matplotlib & Seaborn for both numeric & non-numeric data. Meaningfully visualise aggregate data using Matplotlib and Seaborn. Related learning

Data Science Learning Pathways can be selected by choosing either Python or R and a Cloud Platform certification:

QAIDSDP Introduction to Data Science for Data Professionals Sourcing and handling data: QADHPYTHON Data Handling with Python QADHR Data Handling with R QAPDHAI Python Data Handling with AI APIs Statistics for Data Analysis: QASDAPY Statistics for Data Analysis with Python QASDAR Statistics for Data Analysis with R Programming and Software Development skills: QAPYTH3 Python Programming QARPROG R Programming Machine Learning Development: QADSMLP Data Science and Machine Learning with Python QADSMLR Data Science and Machine Learning with R Mathematics for Developing Algorithms for AI models, Big Data Mining, and working with Neural Networks: QAMFDS Mathematics for Data Science Forecasting: QATSFP Time Series and Forecasting with Python QATSFR Time Series and Forecasting with R

Suggested courses leading to Certification:

MDP100 Designing and Implementing a Data Science Solution on Azure (DP-100) AMWSMLP Machine Learning Pipelines on AWS GCPMLGC Machine Learning on Google Cloud Read more + Free 6-Month Access: Learning Platform Discovery plan

Included FREE with every instructor‑led course

Get free guided access to the QA Learning Platform. Assess your skills, explore in-demand topics, and understand which areas to focus on.

Find out more

Why choose QA Award-winning training, top NPS scores Over 500,000 learners in 2024 Our training experts are industry leaders Read more about QA Learning Pathways Dates & Locations Data, Analytics & AI learning paths

Want to boost your career in data, analytics and AI? Click on the roles below to see QA's learning pathways, specially designed to give you the skills to succeed.

= Required = Certification Data Scientist AI Engineer Data Scientist Fundamentals Fundamentals Introduction to Data Science for Data Professionals QAIDSDP 3 Days £2,340 ex VAT View course Intermediate Intermediate Data Handling in Python QADHPYTHON 3 Days £2,925 ex VAT View course Data Science and Machine Learning with Python QADSMLP 5 Days £5,070 ex VAT View course Data Handling in R QADHR 3 Days £2,925 ex VAT View course Statistics for Data Analysis in Python QASDAPY 2 Days £2,460 ex VAT View course Statistics for Data Analysis in R QASDAR 2 Days £2,460 ex VAT View course Expert Expert Programming in R QARPROG 4 Days £3,850 ex VAT View course Time Series and Forecasting with Python QATSFPY 3 Days £3,695 ex VAT View course Time Series and Forecasting with R QATSFR 3 Days £3,695 ex VAT View course Mathematics for Data Science QAMFDS 5 Days £6,075 ex VAT View course AI Engineer Average salary: £60,000 Fundamentals Fundamentals BCS Essential Certificate in Artificial Intelligence (AI) QAAIBCSE 1 Day £935 ex VAT View course Intermediate Intermediate AI Engineer for GCP

= Required = Certification AI Engineer AI Engineer Fundamentals Fundamentals Introduction to Data Science for Data Professionals QAIDSDP 3 Days £2,340 ex VAT View course Intermediate Intermediate Data Handling in Python QADHPYTHON 3 Days £2,925 ex VAT View course Data Science and Machine Learning with Python QADSMLP 5 Days £5,070 ex VAT View course Expert Expert Machine Learning on Google Cloud GCPMLGC 5 Days £3,385 ex VAT View course Need to know Frequently asked questions How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course.

Once you have purchased the Online course and have completed your registration, you will receive the necessary details to enable you to immediately access it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Let's talk

A member of the team will contact you within 4 working hours after submitting the form.

First Name* Last Name* Business Email Address* Phone* Company Name* Job Title Let's help direct you to the right team* Please select an option I'm new I'm an existing customer What market sector is your business in?* Please select an option Corporate Public Sector I'm looking for myself What industry is your business in?* Please select an option Automotive Energy Financial Services FMCG Healthcare Hospitality Manufacturing Media Professional Services Real Estate Reseller Retail Technology Telecommunications Transport Other Central GOV MOD Charities and Not for Profit Education Emergency Services Gov Services Higher Education Housing Local Gov NHS Other Public Sector Country* Please select an option United Kingdom United States Afghanistan Albania Algeria Angola Anguilla Antigua and Barbuda Argentina Armenia Australia Austria Azerbaijan Bahrain Bangladesh Barbados Belgium Benin Bermuda Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Cameroon Canada Cayman Islands Chile China Colombia Congo Costa Rica Côte d'Ivoire Croatia Cyprus Czech Republic Democratic Republic of Congo Denmark Ecuador Egypt Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Islands Finland France Gambia Georgia Germany Ghana Gibraltar Greece Guernsey Haiti Hong Kong Hungary Iceland India Indonesia Ireland Isle of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kosovo Kuwait Kyrgyzstan Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macedonia Malawi Malaysia Mali Malta Mauritius Mexico Moldova Monaco Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nepal Netherlands New Zealand Nigeria Norway Oman Pakistan Panama Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Republic of Iraq Romania Rwanda Samoa Saudi Arabia Serbia Sierra Leone Singapore Slovakia Slovenia Somalia South Africa South Korea Spain Sri Lanka St.Kitts & Nevis Sudan Swaziland Sweden Switzerland Taiwan Tanzania Thailand Togo Trinidad and Tobago Tunisia Turkey Uganda United Arab Emirates Uruguay Viet Nam Yemen Zambia Zimbabwe Where are you located?* Please select an option London Midlands North England Scotland South England Other Let us know how we can help* I consent to QA sending me marketing communications, including news, events, updates, and offers. I understand I can withdraw this consent at any time by using the unsubscribe link in QA emails or by contacting QA directly.

By submitting this form, you agree to QA processing your data in accordance with our Privacy Policy.

Submit

Footer menu

Ways to learn Self-paced learning Instructor-led learning Blended Learning Experience Apprenticeships Explore our courses Browse self-paced library Browse all training courses Browse all partners Browse all certifications Explore Apprenticeships Degree apprenticeships Apprenticeships in England Apprenticeships in Scotland Global apprenticeship solutions About QA About us Careers Training locations Contact us QA Higher Education Service leavers Teach the Nation Resources Blog Events Case studies FAQs Legal terms Legal & Privacy Modern Slavery Statement Tax strategy Sitemap

QA Limited is registered in England No. 2413137

Our registered office and postal address is:

International House, 1 St Katharine’s Way, London, E1W 1UN

QA USA, Inc. (formerly known as Cloud Academy, Inc.) 530 Fifth Avenue, Suite 703, New York, NY 10036.

QA Logo ®, TAP ® and Cloud Academy logo ® are registered trademarks of QA Limited, in the United Kingdom and the European Union. Cloud Academy ® is registered trademark of QA USA, Inc. (formerly Cloud Academy, Inc.) , in the United States of America.

We may monitor or record telephone calls for training, customer service and quality assurance purposes, and to detect or prevent crime. For further information please see our Privacy Notice.

Your course has been added to your basket

Proceed to checkout Continue shopping

Our basket is temporarily unavailable. Please call us on 01753 898 760 or email NewBusiness@qa.com and we'll be happy to assist you with your booking.

Continue browsing

We can see you're visiting from the Americas. For the most relevant content, switch to our Americas site.

Stay on Global site Go to Americas site

We can see you're visiting from outside the Americas. For the most relevant content, switch to our global site.

Stay on Americas site Go to Global site

This training is exclusively available to the organisations listed below. You may only proceed with your booking if your organisation is named in the list.
Please note: If you complete a booking under an unlisted organisation, your booking will be cancelled and a refund will be issued.

ACAS Attorney General's Office Bank of England British Army Cabinet Office Care Quality Commission City of London Police Civil Aviation Authority Companies House Competition Commission Crown Prosecution Service Defence Academy - Royal College of Defence Studies Defence Digital Defence Science & Technology Agency Defence Science Technology Laboratory Defra Department for Business and Trade Department for Digital Culture Media & Sport Department for Education Department for Environment Food & Rural Affairs Department for Science Innovation and Technology Department for Transport Department for Work and Pensions Department Of Health & Social Care Director General Financial Management DWP Environment Agency Financial Conduct Authority Foreign Commonwealth & Development Office Gambling Commission Health & Safety Executive HISTORIC ENGLAND HM REVENUE & CUSTOMS HM Treasury Home Office Homes England Intellectual Property Office Land Registry Information Systems Office Met Office MHRA Ministry of Defence Ministry of Housing Communities and Local Government Ministry of Justice MOD MoD CTP National Archives National Highways National Institute for Health and Clinical Excellence National Measurement Office Natural History Museum NCA NEST Corporation NHS Blood & Transplant NHS Business Services Authority NHS Digital NHS England NHSE - South London (IT) Nuclear Decommissioning Authority Ofcom Office for National Statistics OFGEM - Office of Gas & Electricity Markets Ombudsman Ordnance Survey Parliamentary Digital Service Pension Protection Fund Royal Air Force Royal Navy Rural Payments Agency Science Museum Group Security Industry Authority Sellafield Ltd Serious Fraud Office Sport England The British Library The British Museum The Crown Estate Commissioners The Insolvency Service The Pensions Regulator The Planning Inspectorate UK Debt Management Office UK EXPORT FINANCE UK Health Security Agency United Kingdom Research & Innovation Valuation Office Agency Victoria and Albert Museum Welsh Assembly Government Add to basket Go back

Data Handling in Python | QA,AI智能索引,全网链接索引,智能导航,网页索引

This three day course is aimed at those wishing to learn how to use Python to work with and handle Data. When combined with our Introduction to Data Science course you would be se