Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Lecture

Data Processing

In course

CH-108(a): Chemistry Laboratory Work I

Familiariser l'étudiant avec le travail au laboratoire. Travailler de façon quantitative et/ou qualitative. TP réalisés en relation avec les cours de chimie de 1ere année et complémentaires avec le contenu des enseignements TP2 dispensés au semestre suiva ...

Description

This lecture covers the processing of data from a chemical experiment, focusing on the analysis of a CSV file containing absorbance values at different wavelengths. The instructor demonstrates how to import, visualize, and analyze the data using Excel, emphasizing the calibration curve and concentration calculations.

Instructors (2)

Anne-Sophie Chauvin

Web of Science Researcher ID F-4905-2011 Google Scholar page: https://scholar.google.ch/citations?user=O_HhJUEAAAAJ&hl=fr&oi=ao ORCID number is 0000-0001-9222-3866 Anne-Sophie Chauvin studied chemistry and biology at the university Paris V-René Descartes in France where she did a PhD in organic chemistry, working on mimetic complexes of the active site of Nitrile Hydratase, under the supervision of Prof. Jean-Claude Chottard. On 1999 she moved for 20 months to the University of Geneva, for a post-doctoral stay under the supervision of Prof. Alexandre Alexakis, where she focused on the determination of the absolute configuration of chiral alcohols using Organophosphorous Diamine Derivatizing Agents by 31P and 1H NMR Spectroscopy. On 2000 she joined the group of Prof Jean-Claude G. Bünzli and was appointed part-time lecturer in 2001, assuming teaching and research responsibilities. On 2006, she obtained the habilitation to direct research from the University René Descartes (HDR, Paris V, France) and since october 2007 she is Maître d'Enseignement et de Recherche at the EPFL. In 2010, she joigned the Laboratory for Photonics and Interfaces (LPI), headed by Pr. Michaël Graëtzel. Since the end of 2014, with the arrival of Dr Marinella Mazzanti at EPFL, she is back to lanthanide chemistry, dealing with coordination polymers. Her research interests concern supramolecular chemistry with the design of ligands which form water soluble complexes with luminescent lanthanides in view of biological applications. She is also interested in the synthesis of ligands and polymers for the extraction of lanthanide ions with high selectivity, and in the development of invisibke inks. She also developed organic dyes for dyes sensitized solar cells DSSC. She is now focusing on coordination polymers with luminescent properties and catalytic activity. Anne-Sophie Chauvin is involved in the teaching of General and Analytical Chemistry for students enrolled on first year in Pharmacy and Biology (UNIL): ex-cathedra courses (Chimie Générale et analytique I et II, approfondissement en chimie analytique pour pharmaciens) and exercices. She is in charge of practical sessions for students enroled in chemistry, forensic sciences, pharmacy and biology. She is elected at the FSB Faculty Council and was member of the EPFL Assembly (AE) for 6 years, until 2018. She was member of the Management committee of the Cost CM 1006 action entitled Eufen: European F-Element Network. She is Member of the Swiss Chemical Society (SCS) and Fellow of the Royal Society of Chemistry (FRSC).

Julien Alexandre Andres

Official source

Related concepts (32)

File format

A file format is a standard way that information is encoded for storage in a . It specifies how bits are used to encode information in a digital storage medium. File formats may be either proprietary or free. Some file formats are designed for very particular types of data: PNG files, for example, store bitmapped using lossless data compression. Other file formats, however, are designed for storage of several different types of data: the Ogg format can act as a container for different types of multimedia including any combination of audio and video, with or without text (such as subtitles), and metadata.

Data Preprocessing

Data preprocessing can refer to manipulation or dropping of data before it is used in order to ensure or enhance performance, and is an important step in the data mining process. The phrase "garbage in, garbage out" is particularly applicable to data mining and machine learning projects. Data collection methods are often loosely controlled, resulting in out-of-range values, impossible data combinations, and missing values, amongst other issues. Analyzing data that has not been carefully screened for such problems can produce misleading results.

Data warehouse

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. Data warehouses are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise. This is beneficial for companies as it enables them to interrogate and draw insights from their data and make decisions.

Data mining

Data mining is the process of extracting and discovering patterns in large data sets involving methods at the intersection of machine learning, statistics, and database systems. Data mining is an interdisciplinary subfield of computer science and statistics with an overall goal of extracting information (with intelligent methods) from a data set and transforming the information into a comprehensible structure for further use. Data mining is the analysis step of the "knowledge discovery in databases" process, or KDD.

Low-pass filter

A low-pass filter is a filter that passes signals with a frequency lower than a selected cutoff frequency and attenuates signals with frequencies higher than the cutoff frequency. The exact frequency response of the filter depends on the filter design. The filter is sometimes called a high-cut filter, or treble-cut filter in audio applications. A low-pass filter is the complement of a high-pass filter. In optics, high-pass and low-pass may have different meanings, depending on whether referring to the frequency or wavelength of light, since these variables are inversely related.

Related lectures (40)

Ergo: ergometry figures

Covers the analysis of ergometry figures using Excel and the interpretation of respiratory and cardiovascular parameters.

Regulations: Figures of Regulations

Covers the analysis of ECG heart rate data and respiratory flow measurements using Excel.

ECG: HR Variability Figures

Explores heart rate variability analysis using ECG data and its physiological significance.

ConsO2 Calibration and Data Analysis

Covers the calibration and data analysis process for ConsO2 measurements, including input file selection and data interpretation.

Data Visualization: Excel Charts