Figure 10. The user interface shows the contents of the newtruckdata.csv file.
Getting ready to run analysis on your new CSV file
Double-click the 'newtruckdata.csv' file. File contents should appear as shown in Figure 10.
Since you now have data, you can open the next Jupyter notebook, simpleCalc.ipynb, and perform the following operations:
- Create a dataframe.
- Perform simple total and average calculations.
- Print the calculation results.
Double-click the simpleCalc.ipynb file. When you execute the cells in the notebook, results appear like the ones shown in Figure 11.
Figure 11. The SimpleCalc.ipynb notebook shows the results of executing its cells.
The cells in Figure 11 show the mileage of four vehicles. In the next cell, we calculate total mileage, total rows (number of vehicles) and the average mileage for all vehicles. Execute the “Perform Calculations” cell to see basic calculations performed on the data (Figure 12).
Figure 12. Calculations show the total mileage as 742, for four vehicles, and an average mileage of 185.5.
Success! You have analyzed your run results using Red Hat OpenShift Data Science.