如何从CSV API有效获取并解析数据：一个JavaScript教程

<script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/5.3.0/papaparse.min.js"></script>

<label for="schoolName">Enter School Name:</label>
<input type="text" id="schoolName" value="Duke University" />
<button onclick="getSchoolInformation()">Get Information</button>

// Function to retrieve school information
function getSchoolInformation() {
  const schoolName = document.getElementById("schoolName").value;
  console.log("尝试查询学校:", schoolName); // 添加调试信息
  fetch('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2020/2020-03-10/tuition_cost.csv')
    .then(response => response.text()) // 获取文本格式的CSV数据
    .then(csvData => {
      const schoolInfo = findSchoolInformation(schoolName, csvData);
      displaySchoolInformation(schoolInfo);
    })
    .catch(error => {
      console.error('API请求或数据处理出错:', error);
    });
}

// Function to find school information based on school name
function findSchoolInformation(schoolName, csvData) {
  const parsedData = Papa.parse(csvData, {
    header: true,         // 将第一行作为对象键名
    skipEmptyLines: true  // 跳过空行
  }).data;
  let schoolInfo = [];

  // ... 后续处理 ...
  return schoolInfo;
}

// Function to find school information based on school name
function findSchoolInformation(schoolName, csvData) {
  const parsedData = Papa.parse(csvData, {
    header: true,
    skipEmptyLines: true
  }).data;
  const schoolInfo = []; // 使用 const 声明，因为数组本身不会重新赋值

  // 遍历解析后的数据
  parsedData.forEach(row => {
    // 使用正确的字段名和点表示法
    const collegeName = row.name;
    const degreeLength = row.degree_length;
    const tuitionCost = row.in_state_tuition;

    // 进行大小写不敏感的匹配
    if (collegeName && collegeName.toLowerCase() === schoolName.toLowerCase()) {
      // 转换数据类型，确保数值计算的准确性
      const parsedDegreeLength = parseInt(degreeLength);
      const parsedTuitionCost = parseFloat(tuitionCost);

      // 验证转换后的数值是否有效
      if (!isNaN(parsedDegreeLength) && !isNaN(parsedTuitionCost)) {
        schoolInfo.push({
          collegeName: collegeName, // 保持原始大小写或根据需求转换
          degreeLength: parsedDegreeLength,
          tuitionCost: parsedTuitionCost
        });
      }
    }
  });
  console.log('筛选后的学校信息:', schoolInfo); // 调试输出
  return schoolInfo;
}

// Function to display school information in the console
function displaySchoolInformation(schoolInfo) {
  if (schoolInfo.length === 0) {
    console.log("未找到匹配的学校信息。");
    return;
  }
  for (let i = 0; i < schoolInfo.length; i++) {
    const collegeName = schoolInfo[i].collegeName;
    const degreeLength = schoolInfo[i].degreeLength;
    const tuitionCost = schoolInfo[i].tuitionCost;

    console.log("学校名称: " + collegeName);
    console.log("学制长度: " + degreeLength + " 年");
    console.log("学费: $" + tuitionCost.toFixed(2));
    console.log("------------------------------");
  }
}