从多个 csv 文件中绘制网站中的数据

时间：2023-10-02

本文介绍了从多个 csv 文件中绘制网站中的数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！

问题描述

我创建了一个静态网站托管在 AWS s3 存储桶上.

I made a static website hosted on an AWS s3 bucket.

我不了解有关 Web 开发的工具和技术，但我举了一个 index.html 代码示例，该代码允许我从名为my_data_file1.csv"的单个文件中绘制数据.

I do not know the tools and technology around web development, but I took an example of index.html code allowing me to plot data from a single file named "my_data_file1.csv".

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta http-equiv="X-UA-Compatible" content="ie=edge" />
    <title>Coding Train: Data and APIs Project 1</title>
    <script src="https://cdn.jsdelivr.net/npm/chart.js@2.8.0"></script>
  </head>
  <body>
    <h1>Global Temperatures</h1>
    <canvas id="myChart" width="400" height="200"></canvas>

    <script>

      window.addEventListener('load', setup);

      async function setup() {
        const ctx = document.getElementById('myChart').getContext('2d');
        const globalTemps = await getData();
        const myChart = new Chart(ctx, {
          type: 'line',
          data: {
            labels: globalTemps.years,
            datasets: [
              {
                label: 'Temperature in °C',
                data: globalTemps.temps,
                fill: false,
                borderColor: 'rgba(255, 99, 132, 1)',
                backgroundColor: 'rgba(255, 99, 132, 0.5)',
                borderWidth: 1
              }
            ]
          },
          options: {}
        });
      }

      async function getData() {
        const response = await fetch('my_data_file1.csv');
        const data = await response.text();
        const years = [];
        const temps = [];
        const rows = data.split('
').slice(1);
        rows.forEach(row => {
          const cols = row.split(',');
          years.push(cols[0]);
          temps.push(parseFloat(cols[2]));
        });
        return { years, temps };
      }
    </script>
  </body>
</html>

我的所有数据都拆分为多个文件，因此我希望能够说明一个目录中的所有 CSV 文件，而不仅仅是一个.我的文件名是可变的，所以我不能一一列出.是否可以将过滤器或正则表达式用作*.csv"?提前致谢，

All of my data is split into multiple files, so I would like to be able to account for all the CSV files in a directory, rather than just one. The name of my files is variable, so I cannot list them one by one. Is it possible to use a filter or RegEx as "*.csv"? Thanks in advance,

从多个 csv 文件中绘制网站中的数据

问题描述

推荐答案

相关文章