Rotational Rheometry Data Processing with Python and Pandas (English subtitles)
Rotational rheometry is a fundamental method for studying the rheological properties of non-Newtonian food media.
××××××××××××××××××××××××××
Course for begginers "TRIZ for a brilliant mind" (in Russian): https://www.b17.ru/go_1ZH
××××××××××××××××××××××××××
The application of the rotational rheometry method makes it possible to obtain graphs of the curves of the flow of food media in the range of shear rates covering 1.5-2 orders of magnitude (for example, from 0.167 to 72.9 1/s or from 1 to 437.4 1/s).
The working element of the rotational viscometers is a system of coaxial cylinders one of them rotates.
The experimental data discussed in the video was obtained on a Rheotest-2 with S2/S cylinder system. The inner (movable) cylinder is S2, the outer (stationary) cylinder is S.
The cylinder system was placed in a thermostat. The circulation of the coolant in the thermostat provided stabilization of the temperature regime during the study.
The video shows one of the ways to prepare rotational viscometry data for subsequent analysis.
The video describes how to recalculate the data (with Python and Pandas) of a dial gauge into shear stress values (Pa) when working on loading and unloading torsion modes, when switching ranges (I-II) during measurement.
The first part of the video is devoted to the description of the course of the experiment, the settings of the viscometer, the features of taking readings from the dial gauge of the viscometer.
The second part of the video examines the Python code. Anaconda3 and Jupiter Notebook are used to write and run the code. The "os" and "pandas" libraries and the "for" loop are used.
In the third part of the video, I talk about how you can improve the code so that it can work with a large amount of data obtained from studying a wide range of non-Newtonian food masses under different experimental conditions.
In the video I say that we build graphs based on data from dataframes but in the video these graphs have not been built. I'm sorry.
=============================
The links I'm talking about in the video.
Description of the Seaborn library for drawing graphs:
https://seaborn.pydata.org/
Description of Python functions for working with an Excel workbook:
https://xlsxwriter.readthedocs.io/ind...
https://realpython.com/openpyxl-excel...
https://www.python-excel.org/
The video author's eLibrary account is Spin-Code: 2675-7351.
=============================
References:
A.H.P. Skelland. Non-Newtonian Flow and Heat Transfer. – Wiley, New York, 1966. – 469 pp.
A. Ya. Malkin, A. I. Isayev. Rheology: Concepts, Methods, and Applications. – ChemTec Publishing, Toronto, 2012. – 472 pp. (https://doi.org/10.1016/C2011-0-04626-4)
P. Ptaszek, S. Basu/ Advances in Food Rheology and Its Applications. – Woodhead Publishing, 2016. – 497 pp. (https://doi.org/10.1016/C2014-0-04114-7)