# Event Details - **Event Name**: Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day - **Event Start and End Date**: Thu, 16 Apr, 2020 at 11:00 am – Wed, 16 Dec, 2026 at 05:00 pm (+01:00) - **Event Description**: Get data from data sources, clean, transform, merge, combine data, prepare data to your required subset of rows, columns, and structure.About this EventPython for Data AnalysisCourse summaryYou would learn to manipulate large and varied datasets by getting hands-on, practical experience working on real-life data problems.You would gain working knowledge of the most commonly used Python modules for data scientists.Get data from data sources, merge and combine it into one or more data sets.Clean your data, re-structure, transform, and manipulate data to make sure it is suitable for your use case.Course deliveryDuration: 1dayTimes: 10am – 4pmLocation: Online or In ClassroomInstructor-led: No training-bots in our classroom yetJoining Instructions: Full joining instructions will be sent ahead of the course.Certificate: PCWorkshops certificate is issued on completionNotes: Includes notes, exercises, code samples, some videos.Laptops, software and datasets:Laptops: Bring your own deviceSoftware: anaconda.com, Spyder or PycharmInstallation assistance: Email us for assistance from our technical professional should you require helpData sets: We will provide sample datasets beforehandPracticalThis course is hands-on and very practical. You will be given many examples and challenges to try out on your ownKey learning outcomesAt the end of this course, you will be able to:Easily clean, prepare, transform, and summarize data trends from large data setsWho should come?Anyone who needs to manage or interact with large datasets.Some basic experience working with data would be useful but is not required to follow the course.The course does not require any prior programming experience.Course Outline:Session 1:Importing your data to Python, from various sources for different data structures.Session 2: Data StructuresLists, Tuples, Sets, Dictionaries. Json Files. Reading and writing CSV and Txtx files in a Python program. Exception Handling.Session 3: DatabaseLinking with SQL Database, Extract datasets from a database for analysis. Select queries, traverse and display query results. Insert Tables, Insert, Update and delete records.Session 4: PandasThe Python Pandas: Dataframes, Series, Indexing, Sorting, Filter, Slicing, Iteration, Functions, Date/Time Functionality. Time series.Session 5: Data Cleaning and preparationRandom Sampling. Finding and filtering data, Replacing values, Finding and filtering Missing data, Remove Duplicates, String objects, Regex. Transforming data using function and mapping, Renaming Axis Indexes, Discretization and Binning.Session 6: Data WranglingHierarchical Indexing, Reorder, Sorting, Stastitics, Dataframe Joins, Merging, Concatenation, and Overlap. Reshaping and pivoting.Your trainer:Sarah Barnard has been a software and database developer for 20+ years. She founded, grew and sold 3 software training companies during this time. She has published 5000+ educational programming scripts, 49 training manuals available on Shopify, manages a Udemy channel and a Programming Languages Meetup group https://cdn-az.allevents.in/events5/banners/b4ffb540-257e-11f1-8500-4f0c3b0bf48e-rimg-w1111-h740-dc63625b-gmir.jpg https://cdn-az.allevents.in/events2/banners/b536a3c0-257e-11f1-a591-7f7175887899-rimg-w555-h740-dc464b4b-gmir.jpg https://cdn-az.allevents.in/events3/banners/b57189e0-257e-11f1-886e-e3e40c802de8-rimg-w740-h740-dc0f75bd-gmir.jpg Agenda🕑: 10:00 AM - 04:00 PMPython Data CourseInfo: Lunchtime 13h00 for 45 minutes - **Event URL**: https://allevents.in/london/python-data-analysis-bootcamp-from-beginner-to-pandas-andamp;-numpy-pro-in-1-day/10000100540932636 - **Event Categories**: workshops, it, meetups - **Interested Audience**: - total_interested_count: 0 - **Event Highlights**: - Duration: 6 hours - Location: PCWorkshops at Regus Near Trafalgar Square - Languages: English ## Ticket Details - **Ticket Price Range**: min: 60.29, max: 276.97, currency: GBP ## Event venue details - **city**: London - **state**: EN - **country**: United Kingdom - **location**: PCWorkshops at Regus Near Trafalgar Square - **lat**: 51.5082843 - **long**: -0.12647149999997964 - **full address**: PCWorkshops at Regus Near Trafalgar Square, Golden Cross House, London, United Kingdom ## Event gallery - **Alt text**: Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day - **Image URL**: https://cdn-az.allevents.in/events4/banners/7f22b2235d55c39b0b0400f5422c99c78ff786055756b3fd92c4b67efe39546b-rimg-w1200-h675-dc177cc7-gmir.jpg?v=1774136158 ## FAQs - **Q**: When and where is Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day being held? - **A:** Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day takes place on Thu, 16 Apr, 2020 at 11:00 am to Wed, 16 Dec, 2026 at 05:00 pm at PCWorkshops at Regus Near Trafalgar Square, Golden Cross House, London, United Kingdom. - **Q**: How much do tickets cost for Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day? - **A:** Ticket prices for Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day range from GBP 60 to GBP 277 depending on the ticket type. Here's a full breakdown of available ticket types:Ticket TypePriceAvailabilityPython Data Course, ONLINE AttendanceGBP 60 + GBP 5 feeAvailablePython Data Course, ClassroomGBP 277 + GBP 22 feeAvailable - **Q**: Who is organizing Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day? - **A:** Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day is organized by PCWorkshops. - **Q**: Who is this event for? Is it right for me? - **A:** Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day is ideal for curious learners, students, and skill-builders looking to gain hands-on knowledge and practical expertise in a focused, interactive setting. Whether you're a first-time attendee or a longtime enthusiast in London, this event is thoughtfully curated to deliver a standout experience worth every moment. If Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day sounds like your kind of event, don't wait - spots fill up fast. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "Python Data Analysis Bootcamp: From Beginner to Pandas & NumPy Pro in 1 Day", "image": "https://cdn-az.allevents.in/events4/banners/7f22b2235d55c39b0b0400f5422c99c78ff786055756b3fd92c4b67efe39546b-rimg-w1200-h675-dc177cc7-gmir.jpg?v=1774136158", "startDate": "2020-04-16T11:00:00+01:00", "endDate": "2026-12-16T17:00:00+01:00", "url": "https://allevents.in/london/python-data-analysis-bootcamp-from-beginner-to-pandas-andamp;-numpy-pro-in-1-day/10000100540932636", "eventStatus": "https://schema.org/EventScheduled", "location": { "@type": "Place", "name": "PCWorkshops at Regus Near Trafalgar Square", "address": { "@type": "PostalAddress", "streetAddress": "Golden Cross House", "postalCode": "WC2N 4JF", "addressLocality": "London", "addressRegion": "EN", "addressCountry": "GB" }, "geo": { "@type": "GeoCoordinates", "latitude": "51.5082843", "longitude": "-0.12647149999997964" } }, "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode", "description": "Get data from data sources, clean, transform, merge, combine data, prepare data to your required subset of rows, columns, and structure.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-21", "availabilityEnds": "2026-12-16T17:00:00+01:00", "validFrom": "2026-03-21", "lowPrice": "60.29", "highPrice": "276.97", "price": "60.29", "url": "https://allevents.in/london/python-data-analysis-bootcamp-from-beginner-to-pandas-andamp;-numpy-pro-in-1-day/10000100540932636" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-21", "availabilityEnds": "", "validFrom": "2026-03-21", "url": "https://allevents.in/london/python-data-analysis-bootcamp-from-beginner-to-pandas-andamp;-numpy-pro-in-1-day/10000100540932636", "price": "60.29", "name": "Python Data Course, ONLINE Attendance" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-21", "availabilityEnds": "", "validFrom": "2026-03-21", "url": "https://allevents.in/london/python-data-analysis-bootcamp-from-beginner-to-pandas-andamp;-numpy-pro-in-1-day/10000100540932636", "price": "276.97", "name": "Python Data Course, Classroom" } ], "organizer": [ { "@type": "Organization", "name": "PCWorkshops", "url": "https://allevents.in/org/pcworkshops/22620392", "description": "At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content." } ] } ] ```