Python Demo: Read Data from Excel, Plot it, and Fit it to an Exponential

In this video we look at a Python program that uses the pandas and openpyxl modules to read in data from Excel. We use the resulting data frame to extract two lists one for our x's and the other for our y's. In this example the data is the voltage across a discharging capacitor as a function of time. We then use matplotlib to plot the data. We follow this by using numpy's polynomial fit and the usual method of taking a log of the y values and fitting to a straight line. We return to matplotlib to plot and display the fit equation.