The Pandas Workshop: A comprehensive guide to using Python for data analysis with real-world case studies

Learn the fundamentals of data science with Python by analyzing real datasets and solving problems using pandasKey FeaturesLearn how to apply data retrieval, transformation, visualization, and modeling techniques using pandasBecome highly efficient in unlocking deeper insights from your data, including databases, web data, and moreBuild your experience and confidence with hands-on exercises and activitiesBook DescriptionThe Pandas Workshop will teach you how to be more productive with data and generate real business insights to inform your decision-making. You will be guided through real-world data science problems and shown how to apply key techniques in the context of realistic examples and exercises. Engaging activities will then challenge you to apply your new skills in a way that prepares you for real data science projects.You'll see how experienced data scientists tackle a wide range of problems using data analysis with pandas. Unlike other Python books, which focus on theory and spend too long on dry, technical explanations, this workshop is designed to quickly get you to write clean code and build your understanding through hands-on practice. As you work through this Python pandas book, you'll tackle various real-world scenarios, such as using an air quality dataset to understand the pattern of nitrogen dioxide emissions in a city, as well as analyzing transportation data to improve bus transportation services.By the end of this data analytics book, you'll have the knowledge, skills, and confidence you need to solve your own challenging data science problems with pandas.What you will learnAccess and load data from different sources using pandasWork with a range of data types and structures to understand your dataPerform data transformation to prepare it for analysisUse Matplotlib for data visualization to create a variety of plotsCreate data models to find relationships and test hypothesesManipulate time-series data to perform date-time calculationsOptimize your code to ensure more efficient business data analysisWho this book is forThis data analysis book is for anyone with prior experience working with the Python programming language who wants to learn the fundamentals of data analysis with pandas. Previous knowledge of pandas is not necessary.Table of ContentsAn Introduction to pandasWorking with Data StructuresData I/Opandas Data TypesData Selection – DataFramesData Selection – SeriesData Exploration and TransformationData VisualizationData Modeling – PreprocessingData Modeling – Modeling BasicsData Modeling – Regression ModelingUsing Time in pandasExploring Time SeriesApplying pandas Data Processing for Case Studies