book

Practical Data Analysis Using Jupyter Notebook

by Marc Wintjen

June 2020

Intermediate to advanced

322 pages

7h 25m

English

Packt Publishing

Read now

Unlock full access

Practical Data Analysis using Jupyter Notebook
Why subscribe?
About the authorAbout the reviewersPackt is searching for authors like you
Who this book is forWhat this book coversTo get the most out of this bookDownload the example code filesDownload the color imagesConventions usedGet in touchReviews
The evolution of data analysis and why it is importantWhat makes a good data analyst?Know Your Data (KYD)Voice of the Customer (VOC)Always Be Agile (ABA)Understanding data types and their significanceUnstructured dataSemi-structured dataStructured dataCommon data typesData classifications and data attributes explainedData attributesUnderstanding data literacyReading dataWorking with dataAnalyzing dataArguing about the dataSummaryFurther reading
Technical requirementsInstalling Python and using Jupyter NotebookInstalling AnacondaRunning Jupyter and installing Python packages for data analysisStoring and retrieving data filesHello World! – running your first Python codeCreating a project folder hierarchyUploading a fileExploring Python packagesChecking for pandasChecking for NumPyChecking for sklearnChecking for MatplotlibChecking for SciPySummaryFuture reading
Technical requirementsUnderstanding a Python NumPy array and its importanceDifferences between single and multiple dimensional arraysMaking your first NumPy arrayUseful array functionsPractical use cases of NumPy and arraysAssigning values to arrays manuallyAssigning values to arrays directlyAssigning values to an array using a loopSummaryFurther reading

Technical requirementsTechniques for manipulating tabular dataUnderstanding pandas and DataFramesHandling essential data formatsCSVXMLData hierarchyDefined schemaJSONData dictionaries and data typesCreating our first DataFrame SummaryFurther reading
Technical requirementsIntroduction to SQL and relational databasesFrom SQL to pandas DataFramesData about your data explainedFundamental statisticsMetadata explainedThe importance of data lineageData flowThe input stageThe data ingestion stageThe data source stageThe data target stageBusiness rulesSummaryFurther reading
Technical requirementsData modeling for results Introducing dimensions and measuresAnatomy of a chart and data viz best practicesAnalyzing your dataWhy pie charts have lost groundArt versus scienceWhat makes great data visualizations? Comparative analysisDate and time trends explainedThe shape of the curveCreating your first time series chart SummaryFurther reading
Technical requirementsRetrieving, viewing, and storing tabular dataRetrievingViewing StoringLearning how to restrict, sort, and sift through dataRestrictingSortingSiftingCleaning, refining, and purifying data using PythonCombining and binning dataBinningSummaryFurther reading
Technical requirementsFoundations of join relationshipsOne-to-one relationshipsMany-to-one relationshipsMany-to-many relationshipLeft joinRight joinInner joinOuter joinJoin types in actionExplaining data aggregationUnderstanding the granularity of dataData aggregation in actionSummary statistics and outliersSummaryFurther reading<a href="https://matplotlib.org/index.html">
Technical requirementsExplaining distribution analysisKYDShape of the curveUnderstanding outliers and trendsGeoanalytical techniques and tipsFinding patterns in dataSummaryFurther reading
Technical requirementsPreparing to work with unstructured dataCorpus in actionTokenization explainedTokenize in actionCounting words and exploring resultsCounting wordsNormalizing text techniquesStemming and lemmatization in actionExcluding words from analysisSummaryFurther reading
Technical requirementsWhy sentiment analysis is importantElements of an NLP modelCreating a prediction outputSentiment analysis packagesSentiment analysis in actionManual inputSocial media file inputSummaryFurther reading
Technical requirementsDiscovering real-world datasetsData.govThe Humanitarian Data ExchangeThe World BankOur World in DataReporting resultsStorytellingThe Capstone projectKYD sourcesExerciseSummaryFurther reading
Leave a review - let other readers know what you think

Content preview from Practical Data Analysis Using Jupyter Notebook

Gathering and Loading Data in Python

This chapter will explain what SQL isand why it is important for data analysis by teaching you how to use and access databases using SQLite for our examples. An overview of relational database technology will be provided along with insightful information on database systems to help to improve your data literacy when communicating with experts. You will also learn how to run SQLSELECTqueries from the Jupyter Notebook and how to load them into DataFrames. Basic statistics, data lineage, and metadata (data about data) will be explained using thepandaslibrary.

We will cover the following topics in this chapter:

Introduction to SQL and relational databases
From SQL to pandas DataFrames
Data about your data ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Beginning Data Science in R 4: Data Analysis, Visualization, and Modelling for the Data Scientist

Publisher Resources

ISBN: 9781838826031Supplemental Content

Practical Data Analysis Using Jupyter Notebook

by Marc Wintjen

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Beginning Data Science in R 4: Data Analysis, Visualization, and Modelling for the Data Scientist

How I Built a Personal Board of Directors With GenAI

How to Become a Game-Changing Leader

What Successful Project Managers Do

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Beginning Data Science in R 4: Data Analysis, Visualization, and Modelling for the Data Scientist

How I Built a Personal Board of Directors With GenAI

How to Become a Game-Changing Leader

What Successful Project Managers Do

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.