How to make a FTIR spectra in excel from a CSV file

jezdez1
7 Aug 201712:54
EducationalLearning
32 Likes 10 Comments

TLDRThis video tutorial guides viewers on creating an FTIR graph from CSV file data. It covers inserting blank spaces, labeling columns, formatting data, plotting graphs, adjusting axis scales, and exporting the graph into a Word document. The focus is on clarity and readability, with tips on graph aesthetics and data presentation.

Takeaways
  • 📈 Start by inserting blank spaces above your data in a CSV file to prepare for graphing.
  • 📋 Label the first column as 'Wave Number (cm⁻¹)' and the second column as 'Absorbance' for clarity.
  • 🔍 Change the format of the wave number column from scientific to a more recognizable number format with zero decimal places.
  • 📊 Ensure the absorbance column is also formatted as a number, possibly with four decimal places for precision.
  • ❌ Delete any data points at the end of the absorbance column that go to zero, as they can distort the graph.
  • 📉 When plotting, use a scatter chart with lines to connect the data points, choosing between a curve or straight lines based on preference.
  • 🔄 Adjust the axis direction so that the wave number (x-axis) decreases from right to left, which is standard for infrared graphs.
  • 📌 Set the x-axis to start at the maximum value, typically 4000 cm⁻¹, to match the standard infrared graph scale.
  • 📐 Modify the y-axis to display absorbance values between 0.3 and 0, excluding negative values for better readability.
  • 🏷️ Add axis labels such as 'Wave Number (cm⁻¹)' for the x-axis and 'Absorbance' for the y-axis to provide context.
  • 🖌️ When exporting the graph to a document, ensure lines and grid marks are black for consistency and clarity, and paste the graph as a picture to prevent editing in the document.
Q & A
  • What is the main topic of the video?

    -The video is about how to create an FTIR (Fourier Transform Infrared Spectroscopy) graph from data in a CSV file.

  • What are the two columns required in the CSV file for making an FTIR graph?

    -The two columns required are 'a' and 'b', which represent the wave number and absorbance, respectively.

  • Why is it necessary to insert blank spaces above the data in the CSV file before creating the graph?

    -Blank spaces are inserted to provide room for adding a sample description and column headers, which helps in organizing and identifying the data.

  • What is the purpose of changing the format of the wave number column from scientific to number?

    -Changing the format makes the wave number more recognizable and easier to understand in the context of an infrared graph.

  • How should the data points be represented in the FTIR graph?

    -The data points should be represented as a line graph, with the option to choose between a smooth curve or straight lines connecting the points.

  • What is the typical direction of the x-axis in an FTIR graph?

    -In a standard FTIR graph, the x-axis usually goes from right to left, showing wave numbers.

  • Why is it important to reverse the order of the axis values in the FTIR graph?

    -Reversing the axis values aligns the graph with the conventional presentation of FTIR spectra, where lower wave numbers are on the right.

  • How can the graph's readability be improved?

    -The readability can be improved by adjusting the number of decimal places, setting axis limits, and adding axis labels.

  • What should be considered when exporting the graph to a Word document?

    -When exporting, it's important to remove any unnecessary grid lines, ensure the graph has no borders, and paste it as a picture to prevent editing within Word.

  • What is the significance of adjusting the y-axis absorbance values when stacking FTIR spectra in a report?

    -Adjusting the y-axis values prevents overlap between stacked spectra, making each spectrum distinct and easier to analyze.

  • Why might the color of lines and text in the graph need to be changed before including it in a report?

    -Colors may be changed to black for consistency and to ensure that the graph is clear and professional-looking in a printed report.

Outlines
00:00
📊 Creating an FTIR Graph from CSV Data

This paragraph outlines the process of creating a Fourier Transform Infrared Spectroscopy (FTIR) graph from data in a CSV file. The video demonstrates how to format the data with two columns, labeled 'a' and 'b', which represent wave numbers and absorbance values, respectively. It emphasizes the importance of inserting blank spaces for clarity, adding a sample description, and adjusting column widths for better readability. The wave number is initially in scientific notation but is then formatted to a more recognizable number format with zero decimal places. The absorbance data is also formatted to improve clarity, and any data points that do not contribute to the graph, such as the last reading that goes to zero, are removed. The video also discusses the typical orientation of an FTIR graph, which is from right to left, starting from 4000 and ending at 400 cm^-1, and how to adjust the graph to reflect this.

05:00
📈 Customizing and Enhancing the FTIR Graph

The second paragraph delves into customizing the FTIR graph for better readability and accuracy. It explains how to adjust the axis scales to show only two decimal places, set the minimum and maximum values appropriately, and ensure the graph reflects the correct range of absorbance values. The video also covers adding axis labels, such as 'Wave number cm^-1' and 'Absorbance', and the option to remove the scale for absorbance if it's not required. It touches on the importance of grid marks for easier reading and suggests adjusting the graph's magnification for clarity. Additionally, the paragraph discusses the possibility of showing two graphs for comparison, such as an expanded view focusing on specific peaks, and the need to adjust line colors and styles for consistency and professionalism in reports.

10:01
🖋️ Incorporating the FTIR Graph into a Report

The final paragraph focuses on integrating the completed FTIR graph into a report or document. It describes the process of copying the graph from the spreadsheet and pasting it into a Word document as a picture to prevent further editing within the document. The video mentions the importance of removing any unnecessary lines or borders from the graph before exporting it to maintain a clean and professional appearance. It also discusses the potential need to adjust the graph's axis values when stacking multiple spectra to avoid overlap and ensure clarity. The paragraph concludes with a reminder to consider offsetting the y-axis absorbance values when stacking graphs and a note on changing line colors to black for a more formal report presentation.

Mindmap
Keywords
💡FTIR
FTIR stands for Fourier Transform Infrared Spectroscopy, a technique used to obtain an infrared spectrum of absorption or emission of a solid, liquid or gas. In the video, the main theme revolves around creating an FTIR graph from data in a CSV file, demonstrating the practical application of this scientific method.
💡CSV file
A CSV file, or Comma Separated Values file, is a type of file used to store tabular data, typically in plain text. In the video, the CSV file is the source of data for creating the FTIR graph, containing two columns of data which are crucial for the analysis.
💡Wave number
The wave number is a measure used in spectroscopy that is inversely proportional to the wavelength of a wave. In the context of the video, the wave number is one of the two columns in the CSV file and is used as the x-axis in the FTIR graph, indicating the frequency of the infrared light.
💡Absorbance
Absorbance is a measure of the amount of light absorbed by a sample in spectroscopy. In the video, absorbance is the second column in the CSV file and is used as the y-axis in the FTIR graph, representing how much light is absorbed at each wave number.
💡Scientific form
Scientific form, or scientific notation, is a way of expressing numbers that are too big or too small to be conveniently written in decimal form. In the video, the wave number is initially in scientific form, but the presenter changes it to a more recognizable number format for easier interpretation.
💡Scatter chart
A scatter chart is a type of plot that displays the values of two variables for a set of data. In the video, the presenter uses a scatter chart to visualize the data from the CSV file, specifically choosing to connect the data points with a line to create the FTIR graph.
💡Axis
In graphing, an axis is a line that serves as a reference for the values of the variables being plotted. The video discusses adjusting the axes in the FTIR graph, including reversing the order of values and setting the range, to better represent the data.
💡Decimal places
Decimal places refer to the number of digits after the decimal point in a number. In the video, the presenter adjusts the number of decimal places displayed in the graph to make the data clearer and more precise.
💡Graph labels
Graph labels are textual descriptions that identify the axes and provide context for the data being displayed. In the video, the presenter adds labels to the axes of the FTIR graph, such as 'Wave number cm^-1' and 'Absorbance', to make the graph more informative.
💡Word document
A Word document is a file format used by Microsoft Word for creating and editing documents. In the video, the presenter discusses how to export the FTIR graph from Excel and insert it into a Word document, which is a common practice for reporting and presenting scientific data.
💡Paste as picture
Pasting as a picture is a method of inserting content into a document in a format that cannot be edited. In the video, the presenter emphasizes the importance of pasting the graph as a picture in the Word document to ensure that it remains unaltered and consistent with the original.
Highlights

Introduction to creating an FTIR graph from CSV file data with two columns labeled 'a' and 'b'.

Inserting blank spaces above the data for additional information.

Adding a sample description at the top of the data set.

Labeling the first column as 'Wave number cm⁻¹' and adjusting column width for clarity.

Changing the format of the wave number column from scientific to a more recognizable number format with zero decimal places.

Adjusting the absorbance column to display with four decimal places for precision.

Deleting the last data point where absorbance goes to zero for a more typical graph appearance.

Selecting the correct chart type for the FTIR graph, choosing between a current line or straight lines.

Reversing the axis order to match the standard FTIR graph format, with higher values on the left.

Adjusting the x-axis range to start at 4000 instead of 0 for better visualization.

Specifying the y-axis to show only two decimal places for easier readability.

Setting the y-axis minimum to 0 to exclude negative values.

Adding axis labels for 'Wave number cm⁻¹' and 'Absorbance'.

Discussing the option to show or hide the scale of absorbance in an infrared spectrum.

Improving graph readability with grid marks and adjusting the scale increments.

Demonstrating how to copy and paste the graph into a Word document while maintaining its integrity.

Explaining the process of adjusting line colors and styles for a professional report appearance.

Providing tips on how to stack multiple FTIR graphs with offset adjustments for clarity.

Final review and summary of the process to create and export an FTIR graph for reporting.

Transcripts
Rate This

5.0 / 5 (0 votes)

Thanks for rating: