Lecture

Data Processing

Graph Chat

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.

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 (31)

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.

Filter design

Filter design is the process of designing a signal processing filter that satisfies a set of requirements, some of which may be conflicting. The purpose is to find a realization of the filter that meets each of the requirements to a sufficient degree to make it useful. The filter design process can be described as an optimization problem where each requirement contributes to an error function that should be minimized. Certain parts of the design process can be automated, but normally an experienced electrical engineer is needed to get a good result.

Comma-separated values

Comma-separated values (CSV) is a format that uses commas to separate values. A CSV file stores tabular data (numbers and text) in plain text, where each line of the file typically represents one data record. Each record consists of the same number of fields, and these are separated by commas in the CSV file. If the field delimiter itself may appear within a field, fields can be surrounded with quotation marks . The CSV file format is one type of delimiter-separated file format.

Related lectures (64)

Water Consumption in Geneva

Explores water consumption data in Geneva, including charts on consumption and losses, available datasets, and data processing phases.

Air Pollution Data Analysis

Covers the analysis of air pollution data, focusing on R basics, visualizing time series, and creating summaries of pollutant concentrations.

Reservoirs and Dams: Hydraulic Construction and Sizing

Explores sizing reservoirs and dams using cumulative flow curves and tank dimensioning for dry and rainy periods.

Big Data: Processing and Dimensions

Explores Big Data generation, storage, processing, and dimensions, along with challenges in data analytics, cloud computing elasticity, and security.

Data Wrangling with Hive: Managing Big Data Efficiently