Data Analysis and Visualization

\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Differential \newcommand\dd[2][]{\mathrm{d}^{#1}{#2}} % use as \dd, \dd{x}, or \dd[2]{x}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{{\kern-4mu}\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{\kern-4mu}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Capacitance \newcommand\farad{\unit{F}} \newcommand\F{\farad} \newcommand\microfarad{\micro\farad} \newcommand\muF{\micro\farad} % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch % NOTE: do NOT define \bar -- it is the built-in LaTeX accent used by \bar{x}, % \bar{y} (sample means). Redefining it made those render as the word "bar". \newcommand\barunit{\unit{bar}} \end{aligned}\end{align} \]

Nov 16, 2026 | 356 words | 4 min read

11. Data Analysis and Visualization#

Topics Covered

  • Introduction to the NumPy, pandas, and matplotlib libraries

  • NumPy arrays, array properties, and vectorized operations

  • Indexing and slicing arrays

  • Loops vs. NumPy vs. pandas for calculations

  • pandas Series and DataFrames

  • Importing and exporting data (CSV, text, and Excel files)

  • Selecting, filtering, and sorting data

  • Creating new calculated columns

  • Merging, grouping, and aggregating data

  • Cleaning data (missing values, duplicates, invalid points, and renaming columns)

  • Descriptive statistics

  • Working with dates and times

  • Line plots, scatter plots, bar charts, and histograms

  • Plotting multiple datasets and using two y-axes

  • Professional plot formatting (titles, labels, legends, grids, colors, and markers)

  • Saving figures as image files

Skills and Learning Objectives

At the end of this module, you will be able to:

  • Explain what the NumPy, pandas, and matplotlib libraries are and why engineers use them

  • Create NumPy arrays and use them for fast, vectorized calculations and statistical analysis

  • Compare plain Python loops, NumPy, and pandas, and choose the right tool for a task

  • Import data from CSV and Excel files into pandas DataFrames

  • Inspect, select, sort, filter, group, and combine data in a DataFrame

  • Clean data by handling missing values, removing invalid points, and renaming columns

  • Calculate descriptive statistics such as mean, median, standard deviation, minimum, and maximum

  • Create professional engineering plots, including line plots, scatter plots, bar charts, histograms, and plots with two y-axes

  • Format plots with clear titles, axis labels, units, legends, grids, colors, and markers

  • Save plots as image files and export data to CSV, text, or Excel files

  • Interpret data trends and communicate findings clearly

These skills are directly connected to the following Learning Objectives:

PR01:

Programming Standards - Develop code that follows established programming standards and conventions.

PR02:

Data Storage - Store and access data appropriately.

PR03:

Calculations - Perform algebraic, array, relational, and logical operations using a programming language. Effectively utilize built-in functions.

PR05:

Code Structures - Understand and write sequential and non-sequential code structures to achieve a programming objective.

PR06:

Translate Program Descriptions - Translate written descriptions or flowcharts into working code.

PR07:

Test Cases and Tracking - Test and track information through flowcharts and programs.

PR08:

Debugging - Debug and refine code so that it achieves its objective without dynamic or semantic errors.