bcc_etl.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'font_size': 0.4,\n",
       " 'font_color': '#FFFFFF',\n",
       " 'background_alpha': 0.5,\n",
       " 'background_color': '#9C27B0',\n",
       " 'stroke': 'none',\n",
       " 'body': [{'from': 0.52,\n",
       "   'to': 3.36,\n",
       "   'location': 2,\n",
       "   'content': '欢迎来到laslook的介绍'},\n",
       "  {'from': 3.36, 'to': 6.16, 'location': 2, 'content': 'laslook是lastools的新工具'},\n",
       "  {'from': 6.16,\n",
       "   'to': 12.28,\n",
       "   'location': 2,\n",
       "   'content': '处理开放las或laz格式的点云数据的终极工具'},\n",
       "  {'from': 12.28, 'to': 15.16, 'location': 2, 'content': '我们希望您了解什么是点云'},\n",
       "  {'from': 15.16, 'to': 19.43, 'location': 2, 'content': '以及lastools的普遍可能性'},\n",
       "  {'from': 19.43, 'to': 21.25, 'location': 2, 'content': '程序启动后'},\n",
       "  {'from': 21.25, 'to': 23.22, 'location': 2, 'content': '您将看到主屏幕'},\n",
       "  {'from': 23.22,\n",
       "   'to': 26.025,\n",
       "   'location': 2,\n",
       "   'content': '这更像是一个工作环境，而不是单一窗口'},\n",
       "  {'from': 26.125,\n",
       "   'to': 30.75,\n",
       "   'location': 2,\n",
       "   'content': '在左上角，您将看到lastools的所有工具'},\n",
       "  {'from': 30.75,\n",
       "   'to': 36.73,\n",
       "   'location': 2,\n",
       "   'content': '下方，我们提供了一个文件浏览器\\n您可快速了解正常处理的文件概况'},\n",
       "  {'from': 36.73, 'to': 38.39, 'location': 2, 'content': '在文件浏览器下方'},\n",
       "  {'from': 38.39, 'to': 42.79, 'location': 2, 'content': '提供了所选文件的快速预览'},\n",
       "  {'from': 42.79,\n",
       "   'to': 45.709,\n",
       "   'location': 2,\n",
       "   'content': '在主工作区\\n提供了不同的模块的选项卡集合'},\n",
       "  {'from': 45.709, 'to': 46.609, 'location': 2, 'content': '默认设置下'},\n",
       "  {'from': 46.609, 'to': 53.43, 'location': 2, 'content': '可访问3D查看器、文档和参数查找器'},\n",
       "  {'from': 53.43,\n",
       "   'to': 57.31,\n",
       "   'location': 2,\n",
       "   'content': '下方为执行区域、Console控制台窗口'},\n",
       "  {'from': 57.31, 'to': 63.8, 'location': 2, 'content': '我们将从各个方面逐步介绍'},\n",
       "  {'from': 63.8,\n",
       "   'to': 67.58,\n",
       "   'location': 2,\n",
       "   'content': '在工具列表中，您将看到每个工具及其单行描述'},\n",
       "  {'from': 67.58, 'to': 69.9, 'location': 2, 'content': '选择工具将显示参数'},\n",
       "  {'from': 69.9, 'to': 73.21, 'location': 2, 'content': '或所选工具在参数列中'},\n",
       "  {'from': 73.21, 'to': 76.69, 'location': 2, 'content': '选择参数将显示该参数的参数'},\n",
       "  {'from': 76.69, 'to': 79.86, 'location': 2, 'content': '并且可能会显示该参数的样本'},\n",
       "  {'from': 79.86, 'to': 81.12, 'location': 2, 'content': '在两个窗口中'},\n",
       "  {'from': 81.12,\n",
       "   'to': 85.88,\n",
       "   'location': 2,\n",
       "   'content': '您都有一个过滤字段，以递增方式过滤此列表中的项目'},\n",
       "  {'from': 85.88,\n",
       "   'to': 91.76,\n",
       "   'location': 2,\n",
       "   'content': '此功能可让您快速了解可用的工具及其参数'},\n",
       "  {'from': 91.76, 'to': 94.3, 'location': 2, 'content': '如果您想更详细地查看工具'},\n",
       "  {'from': 94.3, 'to': 97.12, 'location': 2, 'content': '您可以简单地切换到工具文档'},\n",
       "  {'from': 97.12, 'to': 102.47, 'location': 2, 'content': '查看工具文档将与所选工具同步'},\n",
       "  {'from': 102.47,\n",
       "   'to': 106.89,\n",
       "   'location': 2,\n",
       "   'content': '您收到的信息您可能已经通过readme文件知道'},\n",
       "  {'from': 106.89, 'to': 109.61, 'location': 2, 'content': '有一些额外的优势'},\n",
       "  {'from': 109.61, 'to': 112.19, 'location': 2, 'content': '首先，我们有一个格式化的视图'},\n",
       "  {'from': 112.19,\n",
       "   'to': 116.78,\n",
       "   'location': 2,\n",
       "   'content': 'readme的markdown被用于着色内容'},\n",
       "  {'from': 116.78,\n",
       "   'to': 122.14,\n",
       "   'location': 2,\n",
       "   'content': '然后，我们可以使用标题结构来生成内容列表'},\n",
       "  {'from': 122.14,\n",
       "   'to': 126.86,\n",
       "   'location': 2,\n",
       "   'content': '您可以单击内容条目以跳转到文件中的位置'},\n",
       "  {'from': 126.86,\n",
       "   'to': 131.14,\n",
       "   'location': 2,\n",
       "   'content': '要么直接在编辑窗口中，要么在过滤字段中'},\n",
       "  {'from': 131.14, 'to': 133.51, 'location': 2, 'content': '您可以输入搜索词'},\n",
       "  {'from': 133.51, 'to': 136.97, 'location': 2, 'content': '此术语用于在当前文档中搜索'},\n",
       "  {'from': 136.97, 'to': 139.73, 'location': 2, 'content': '以及所有道文档'},\n",
       "  {'from': 139.73, 'to': 142.61, 'location': 2, 'content': '在文件中的高亮显示找到的位置'},\n",
       "  {'from': 143.69,\n",
       "   'to': 148.13,\n",
       "   'location': 2,\n",
       "   'content': '在其他文件中的位置列出了全局结果列表'},\n",
       "  {'from': 148.45, 'to': 152.92, 'location': 2, 'content': '使用f三或f四迭代匹配'},\n",
       "  {'from': 152.92, 'to': 155.36, 'location': 2, 'content': '单击全局结果列'},\n",
       "  {'from': 155.36, 'to': 158.82, 'location': 2, 'content': '在第一个位置打开所选文件'},\n",
       "  {'from': 158.82, 'to': 162.26, 'location': 2, 'content': '但如果您不知道正在查找的参数'},\n",
       "  {'from': 162.26, 'to': 165.36, 'location': 2, 'content': '或者哪个工具适合某个任务'},\n",
       "  {'from': 165.36, 'to': 166.33, 'location': 2, 'content': '嗯'},\n",
       "  {'from': 166.33,\n",
       "   'to': 170.73,\n",
       "   'location': 2,\n",
       "   'content': '我们为这个问题构建了一个全局参数数据库'},\n",
       "  {'from': 170.73,\n",
       "   'to': 178.31,\n",
       "   'location': 2,\n",
       "   'content': '此数据库包含所有工具的所有参数以及它们的描述和可能的参数'},\n",
       "  {'from': 178.31, 'to': 183.71, 'location': 2, 'content': '全球搜索框允许扫描所有参数和描述'},\n",
       "  {'from': 183.71, 'to': 186.849, 'location': 2, 'content': '因此，如果您输入hp'},\n",
       "  {'from': 186.849,\n",
       "   'to': 191.15,\n",
       "   'location': 2,\n",
       "   'content': '你将看到所有以hp作为参数的工具'},\n",
       "  {'from': 191.15, 'to': 194.8, 'location': 2, 'content': '你也会看到这些参数属于哪个组'},\n",
       "  {'from': 194.8,\n",
       "   'to': 199.579,\n",
       "   'location': 2,\n",
       "   'content': '如果你对以hp作为输出格式的工具感兴趣'},\n",
       "  {'from': 199.579, 'to': 201.339, 'location': 2, 'content': '然后你选择单元格'},\n",
       "  {'from': 201.339,\n",
       "   'to': 206.78,\n",
       "   'location': 2,\n",
       "   'content': '然后你会在工具列表中看到以绿色标记的工具'},\n",
       "  {'from': 206.78, 'to': 208.16, 'location': 2, 'content': '通过选择组'},\n",
       "  {'from': 208.16, 'to': 212.69, 'location': 2, 'content': '你可以独立过滤选定组的结果'},\n",
       "  {'from': 212.97, 'to': 216.63, 'location': 2, 'content': '这个参数数据库加上工具文档'},\n",
       "  {'from': 216.63,\n",
       "   'to': 222.235,\n",
       "   'location': 2,\n",
       "   'content': '给你提供了快速参考信息关于工具的能力'},\n",
       "  {'from': 222.25, 'to': 225.45, 'location': 2, 'content': '但现在让我们来使用这些工具'},\n",
       "  {'from': 225.45, 'to': 229.41, 'location': 2, 'content': '经典的laz工具是命令行工具'},\n",
       "  {'from': 229.41, 'to': 232.47, 'location': 2, 'content': '因此我们集成了一个命令窗口'},\n",
       "  {'from': 232.47,\n",
       "   'to': 236.329,\n",
       "   'location': 2,\n",
       "   'content': '你可能已经知道如何运行laz工具的命令'},\n",
       "  {'from': 236.329, 'to': 237.269, 'location': 2, 'content': '原则上'},\n",
       "  {'from': 237.269, 'to': 238.989, 'location': 2, 'content': '它仍然是完全相同的'},\n",
       "  {'from': 238.989,\n",
       "   'to': 243.24,\n",
       "   'location': 2,\n",
       "   'content': '但我们想让你在构建命令文件时更有信心'},\n",
       "  {'from': 243.24, 'to': 245.08, 'location': 2, 'content': '所以如果你想使用一条命令'},\n",
       "  {'from': 245.08, 'to': 248.44, 'location': 2, 'content': '你只需通过工具列表双击它'},\n",
       "  {'from': 248.64,\n",
       "   'to': 252.8,\n",
       "   'location': 2,\n",
       "   'content': '然后你需要从文件列表中双击你想要处理的数据文件'},\n",
       "  {'from': 253.84,\n",
       "   'to': 257.94,\n",
       "   'location': 2,\n",
       "   'content': '然后你需要过滤并双击你想要使用的参数'},\n",
       "  {'from': 259.21, 'to': 263.77, 'location': 2, 'content': '在这里你可以更改参数的默认值'},\n",
       "  {'from': 265.12, 'to': 270.4, 'location': 2, 'content': '我们添加一个最后的命令并连接到文件'},\n",
       "  {'from': 290.6,\n",
       "   'to': 298.78,\n",
       "   'location': 2,\n",
       "   'content': '最后你按f五来运行整个批次或者按控制返回来仅仅运行所选的命令'},\n",
       "  {'from': 298.78, 'to': 300.74, 'location': 2, 'content': '进程将被启动'},\n",
       "  {'from': 300.74, 'to': 303.46, 'location': 2, 'content': '一些新的执行线程将被打开'},\n",
       "  {'from': 304.46,\n",
       "   'to': 310.06,\n",
       "   'location': 2,\n",
       "   'content': '在执行过程中，我们将为每个任务获得其自己的输出框'},\n",
       "  {'from': 310.06, 'to': 312.04, 'location': 2, 'content': '你将看到工具的输出'},\n",
       "  {'from': 313.32, 'to': 314.89, 'location': 2, 'content': '如果发生错误'},\n",
       "  {'from': 314.89, 'to': 318.37, 'location': 2, 'content': '输出和编辑行将变成红色'},\n",
       "  {'from': 318.37, 'to': 321.19, 'location': 2, 'content': '如果命令执行成功'},\n",
       "  {'from': 321.19, 'to': 324.07, 'location': 2, 'content': '输出会变成绿色'},\n",
       "  {'from': 324.55, 'to': 325.67, 'location': 2, 'content': '在我们的示例中'},\n",
       "  {'from': 325.67, 'to': 326.71, 'location': 2, 'content': '我们收到了一个错误消息'},\n",
       "  {'from': 326.71,\n",
       "   'to': 330.95,\n",
       "   'location': 2,\n",
       "   'content': '因为laz到laz没有创建不存在的输出路径'},\n",
       "  {'from': 330.95, 'to': 332.29, 'location': 2, 'content': '这不是一个问题'},\n",
       "  {'from': 332.29,\n",
       "   'to': 336.66,\n",
       "   'location': 2,\n",
       "   'content': '因为我们可以使用控制台创建这个路径'},\n",
       "  {'from': 339.24,\n",
       "   'to': 344.49,\n",
       "   'location': 2,\n",
       "   'content': '所以laszuk是latools的工作台，适合测试命令，也适合日常工作'},\n",
       "  {'from': 344.49, 'to': 346.53, 'location': 2, 'content': '以及你的自动化工作流'},\n",
       "  {'from': 346.53, 'to': 348.87, 'location': 2, 'content': '如果你有自动化工作流'},\n",
       "  {'from': 348.87,\n",
       "   'to': 352.46,\n",
       "   'location': 2,\n",
       "   'content': '在这里测试命令可能有用，以便运行它们'},\n",
       "  {'from': 352.46, 'to': 355.3, 'location': 2, 'content': '你将继续使用你的经典命令文件'},\n",
       "  {'from': 356.34,\n",
       "   'to': 359.58,\n",
       "   'location': 2,\n",
       "   'content': '这就是为什么你有一个选项可以保存你的控制台内容。'},\n",
       "  {'from': 359.58, 'to': 360.68, 'location': 2, 'content': '对一个命令文件'},\n",
       "  {'from': 360.68,\n",
       "   'to': 366.669,\n",
       "   'location': 2,\n",
       "   'content': '你可以通过对话给出一个名字，或者直接在第一行输入一个评论'},\n",
       "  {'from': 366.669, 'to': 369.109, 'location': 2, 'content': '那个名字将被使用'},\n",
       "  {'from': 370.14,\n",
       "   'to': 375.81,\n",
       "   'location': 2,\n",
       "   'content': '通常情况下，控制台传递机制会尝试并行处理你的任务。'},\n",
       "  {'from': 375.81, 'to': 377.21, 'location': 2, 'content': '如果你不想要这个'},\n",
       "  {'from': 377.21, 'to': 380.53, 'location': 2, 'content': '您只需点击顺序按钮'},\n",
       "  {'from': 380.53, 'to': 381.05, 'location': 2, 'content': '转换'},\n",
       "  {'from': 381.05, 'to': 381.59, 'location': 2, 'content': '逃脱'},\n",
       "  {'from': 381.59,\n",
       "   'to': 386.159,\n",
       "   'location': 2,\n",
       "   'content': '或者点击“取消所有”来重置执行堆栈'},\n",
       "  {'from': 386.159,\n",
       "   'to': 392.2,\n",
       "   'location': 2,\n",
       "   'content': '与控制台工作意味着总是与我们项目中的文件一起工作'},\n",
       "  {'from': 392.24, 'to': 393.36, 'location': 2, 'content': '在左侧'},\n",
       "  {'from': 393.36, 'to': 397.159, 'location': 2, 'content': '您将看到项目中所有文件'},\n",
       "  {'from': 397.159, 'to': 400.199, 'location': 2, 'content': '这是一个集成的文件浏览器'},\n",
       "  {'from': 400.199, 'to': 402.639, 'location': 2, 'content': '您可以通过点击选择文件'},\n",
       "  {'from': 402.639,\n",
       "   'to': 408.28,\n",
       "   'location': 2,\n",
       "   'content': '鼠标滚轮或光标移动一旦您选择了文件'},\n",
       "  {'from': 408.28, 'to': 413.72, 'location': 2, 'content': '文件信息窗口显示文件的初始预览'},\n",
       "  {'from': 413.72,\n",
       "   'to': 419.03,\n",
       "   'location': 2,\n",
       "   'content': '最后文件以您在laz info中熟悉的方式显示'},\n",
       "  {'from': 419.03, 'to': 421.13, 'location': 2, 'content': '文本文件以文本形式显示'},\n",
       "  {'from': 421.13, 'to': 423.45, 'location': 2, 'content': '作为投手投掷时'},\n",
       "  {'from': 423.45,\n",
       "   'to': 428.539,\n",
       "   'location': 2,\n",
       "   'content': '在任何情况下，您可以选择显示文件的十六进制内容'},\n",
       "  {'from': 428.539, 'to': 430.099, 'location': 2, 'content': '预览支持'},\n",
       "  {'from': 430.099, 'to': 434.519, 'location': 2, 'content': '如文本文件和常见图片格式'},\n",
       "  {'from': 434.519, 'to': 437.659, 'location': 2, 'content': '浏览器与控制台同步'},\n",
       "  {'from': 437.659, 'to': 440.079, 'location': 2, 'content': '一旦生成一个新的输出'},\n",
       "  {'from': 440.079, 'to': 443.86, 'location': 2, 'content': '浏览器将在工具栏中显示此文件'},\n",
       "  {'from': 443.86, 'to': 448.07, 'location': 2, 'content': '有几种方法可以更改目录'},\n",
       "  {'from': 448.59, 'to': 450.27, 'location': 2, 'content': '显示目录历史'},\n",
       "  {'from': 450.27, 'to': 451.47, 'location': 2, 'content': '过滤文件'},\n",
       "  {'from': 451.47, 'to': 453.03, 'location': 2, 'content': '或者按名称排序'},\n",
       "  {'from': 453.03, 'to': 455.419, 'location': 2, 'content': '尺寸或变更日期'},\n",
       "  {'from': 455.419,\n",
       "   'to': 460.939,\n",
       "   'location': 2,\n",
       "   'content': '你可以隐藏你不想在列表中看到的文件，然后再次使它们可见'},\n",
       "  {'from': 464.56, 'to': 467.52, 'location': 2, 'content': '现在我想向你展示三维查看器'},\n",
       "  {'from': 467.52,\n",
       "   'to': 470.18,\n",
       "   'location': 2,\n",
       "   'content': '如果你在文件浏览器中选择了一个文件'},\n",
       "  {'from': 470.18, 'to': 473.52, 'location': 2, 'content': '它也会出现在三维查看器中'},\n",
       "  {'from': 473.659, 'to': 474.779, 'location': 2, 'content': '初次观看'},\n",
       "  {'from': 474.779, 'to': 477.399, 'location': 2, 'content': '我们只读了文件中的一千多个点'},\n",
       "  {'from': 477.399,\n",
       "   'to': 481.2,\n",
       "   'location': 2,\n",
       "   'content': '这个简单的技巧使得首次查看非常快速'},\n",
       "  {'from': 481.2,\n",
       "   'to': 485.16,\n",
       "   'location': 2,\n",
       "   'content': '通常来看，只需查看一小部分你的数据就足够了'},\n",
       "  {'from': 485.16, 'to': 489.1, 'location': 2, 'content': '评估点云或结果的质量'},\n",
       "  {'from': 489.1, 'to': 490.9, 'location': 2, 'content': '如果你想查看所有点'},\n",
       "  {'from': 490.9, 'to': 493.7, 'location': 2, 'content': '你只需点击显示所有数据'},\n",
       "  {'from': 493.7, 'to': 498.069, 'location': 2, 'content': '对于每个文件，整个文件将加载'},\n",
       "  {'from': 498.069, 'to': 500.869, 'location': 2, 'content': '你可以决定如何对点进行着色'},\n",
       "  {'from': 500.869, 'to': 502.669, 'location': 2, 'content': '我将在样本上展示我们的瓷砖'},\n",
       "  {'from': 502.669, 'to': 504.229, 'location': 2, 'content': '我们刚刚创建'},\n",
       "  {'from': 504.92, 'to': 507.62, 'location': 2, 'content': '如果选择了按值着色'},\n",
       "  {'from': 507.62, 'to': 510.16, 'location': 2, 'content': '还可以选择颜色方案'},\n",
       "  {'from': 510.16, 'to': 513.69, 'location': 2, 'content': '颜色方案由用户配置'},\n",
       "  {'from': 513.89,\n",
       "   'to': 520.059,\n",
       "   'location': 2,\n",
       "   'content': '此外，您可以更改点的大小和视图的背景'},\n",
       "  {'from': 520.339, 'to': 523.839, 'location': 2, 'content': '视图方向通过鼠标修改最佳'},\n",
       "  {'from': 523.839, 'to': 527.37, 'location': 2, 'content': '只需点击并移动以更改方向'},\n",
       "  {'from': 527.37, 'to': 531.05, 'location': 2, 'content': '默认情况下，Z方向将向上固定'},\n",
       "  {'from': 532.29, 'to': 532.99, 'location': 2, 'content': '按住Shift点击'},\n",
       "  {'from': 532.99, 'to': 536.65, 'location': 2, 'content': '移动将使点云在XY平面内移动'},\n",
       "  {'from': 536.65,\n",
       "   'to': 540.45,\n",
       "   'location': 2,\n",
       "   'content': '按住Ctrl点击将在Z平面内移动云'},\n",
       "  {'from': 540.45,\n",
       "   'to': 545.3,\n",
       "   'location': 2,\n",
       "   'content': '右键移动将使您的观点中心移动到另一个位置'},\n",
       "  {'from': 545.3,\n",
       "   'to': 551.47,\n",
       "   'location': 2,\n",
       "   'content': '这定义了您视图的缩放中心，缩放最好使用鼠标滚轮'},\n",
       "  {'from': 551.47,\n",
       "   'to': 556.05,\n",
       "   'location': 2,\n",
       "   'content': '所有视图属性可以在三维控制面板中查看和更改'},\n",
       "  {'from': 556.05,\n",
       "   'to': 561.5,\n",
       "   'location': 2,\n",
       "   'content': '更多像z缩放这样的属性可以通过控制面板实现'},\n",
       "  {'from': 561.5, 'to': 562.32, 'location': 2, 'content': '此外'},\n",
       "  {'from': 562.32,\n",
       "   'to': 565.74,\n",
       "   'location': 2,\n",
       "   'content': '您可以通过键盘轻松更改所有视图设置'},\n",
       "  {'from': 565.74,\n",
       "   'to': 571.03,\n",
       "   'location': 2,\n",
       "   'content': '这里需要注意的一点是，数字键盘应设置为数字锁定关闭'},\n",
       "  {'from': 571.03,\n",
       "   'to': 577.65,\n",
       "   'location': 2,\n",
       "   'content': '光标键会移动，加减号会缩放，Shift会减小步长'},\n",
       "  {'from': 577.65,\n",
       "   'to': 583.35,\n",
       "   'location': 2,\n",
       "   'content': '控制光标会移动中心，斜杠会切换到顶部左视图，中心会重置视图'},\n",
       "  {'from': 583.35, 'to': 587.14, 'location': 2, 'content': '一个独立的功能是同时显示多个文件'},\n",
       "  {'from': 587.14, 'to': 592.16, 'location': 2, 'content': '一旦启用多视图选项'},\n",
       "  {'from': 592.16, 'to': 595.08, 'location': 2, 'content': '文件将不自动同步'},\n",
       "  {'from': 595.08, 'to': 598.66, 'location': 2, 'content': '您将看到每个文件旁边的视图图标'},\n",
       "  {'from': 598.66, 'to': 602.16, 'location': 2, 'content': '如果我们想以视图显示此文件'},\n",
       "  {'from': 602.16,\n",
       "   'to': 604.48,\n",
       "   'location': 2,\n",
       "   'content': '我们点击这个图标或在上下文菜单中选择该功能'},\n",
       "  {'from': 604.48, 'to': 609.4, 'location': 2, 'content': '默认情况下'},\n",
       "  {'from': 609.4,\n",
       "   'to': 610.56,\n",
       "   'location': 2,\n",
       "   'content': '所有文件都会居中显示，因为我们不知道'},\n",
       "  {'from': 610.56, 'to': 614.16, 'location': 2, 'content': '文件是否有共同的范围基础'},\n",
       "  {'from': 614.16, 'to': 616.59, 'location': 2, 'content': '您可以轻松地移动单个点云'},\n",
       "  {'from': 616.59, 'to': 619.47, 'location': 2, 'content': '如我之前所示'},\n",
       "  {'from': 619.47, 'to': 620.59, 'location': 2, 'content': '使用Shift点击移动'},\n",
       "  {'from': 620.59,\n",
       "   'to': 622.41,\n",
       "   'location': 2,\n",
       "   'content': '如果我们知道或预期文件有共同的基础'},\n",
       "  {'from': 622.41,\n",
       "   'to': 625.85,\n",
       "   'location': 2,\n",
       "   'content': '我们也可以取消选中居中并点击对齐自动'},\n",
       "  {'from': 625.85, 'to': 630.99, 'location': 2, 'content': '文件将按原始位置对齐'},\n",
       "  {'from': 630.99, 'to': 634.22, 'location': 2, 'content': '如果您迷失方向'},\n",
       "  {'from': 634.22, 'to': 636.2, 'location': 2, 'content': '最好将所有数据集居中并重置您的相机'},\n",
       "  {'from': 636.2,\n",
       "   'to': 640.92,\n",
       "   'location': 2,\n",
       "   'content': '很多时候您可能想探索数据中的详细信息'},\n",
       "  {'from': 641.14,\n",
       "   'to': 644.8,\n",
       "   'location': 2,\n",
       "   'content': '我现在想向您展示我们如何轻松地做到这一点'},\n",
       "  {'from': 644.8, 'to': 649.44, 'location': 2, 'content': '在查看器中'},\n",
       "  {'from': 649.44, 'to': 650.56, 'location': 2, 'content': '我们总是以我们的视图中心工作'},\n",
       "  {'from': 651.84, 'to': 654.63, 'location': 2, 'content': '这是你坐标轴运行的地方'},\n",
       "  {'from': 654.63, 'to': 657.05, 'location': 2, 'content': '假设我们想检查这个绿色汽车'},\n",
       "  {'from': 657.05, 'to': 660.01, 'location': 2, 'content': '例如'},\n",
       "  {'from': 660.01, 'to': 660.85, 'location': 2, 'content': '所以首先我们切换到顶视图'},\n",
       "  {'from': 660.85,\n",
       "   'to': 664.025,\n",
       "   'location': 2,\n",
       "   'content': '然后通过XY移动到我们目标的水平方心中'},\n",
       "  {'from': 664.66, 'to': 668.68, 'location': 2, 'content': '使用右键移动'},\n",
       "  {'from': 668.68, 'to': 671.5, 'location': 2, 'content': '然后稍微移动一下以查看当前的高度'},\n",
       "  {'from': 671.78, 'to': 675.73, 'location': 2, 'content': '然后使用控制'},\n",
       "  {'from': 675.73, 'to': 677.47, 'location': 2, 'content': '右键'},\n",
       "  {'from': 677.47, 'to': 677.99, 'location': 2, 'content': '移动到我们目标的垂直中心'},\n",
       "  {'from': 677.99,\n",
       "   'to': 681.65,\n",
       "   'location': 2,\n",
       "   'content': '现在我们可以轻松地放大目标并围绕它移动'},\n",
       "  {'from': 682.15, 'to': 686.75, 'location': 2, 'content': '有时您可能想分离整个数据带'},\n",
       "  {'from': 689.34, 'to': 692.74, 'location': 2, 'content': '可以通过激活截面功能来实现'},\n",
       "  {'from': 692.74,\n",
       "   'to': 696.98,\n",
       "   'location': 2,\n",
       "   'content': '您可以使用鼠标定义截面或在编辑中输入尺寸'},\n",
       "  {'from': 698.18, 'to': 704.98, 'location': 2, 'content': '点击独占以限制视图到平面'},\n",
       "  {'from': 705.86, 'to': 709.4, 'location': 2, 'content': '您可以锁定平面并隐藏它们'},\n",
       "  {'from': 709.4, 'to': 712.82, 'location': 2, 'content': '您可以使用中心按钮在平面前移动相机'},\n",
       "  {'from': 714.06,\n",
       "   'to': 719.069,\n",
       "   'location': 2,\n",
       "   'content': '如果您更改颜色化参数或更改平面尺寸'},\n",
       "  {'from': 719.869, 'to': 724.189, 'location': 2, 'content': '您可以在截面内重新计算数据'},\n",
       "  {'from': 724.189,\n",
       "   'to': 727.469,\n",
       "   'location': 2,\n",
       "   'content': '这些是laluk的一些基本功能'},\n",
       "  {'from': 728.22, 'to': 731.36, 'location': 2, 'content': '如果我们检查主菜单'},\n",
       "  {'from': 731.36, 'to': 733.12, 'location': 2, 'content': '然而还有一些额外的功能'},\n",
       "  {'from': 733.12, 'to': 736.63, 'location': 2, 'content': '首先'},\n",
       "  {'from': 736.63, 'to': 738.17, 'location': 2, 'content': '我们有项目管理'},\n",
       "  {'from': 738.17,\n",
       "   'to': 743.97,\n",
       "   'location': 2,\n",
       "   'content': '这个功能可以让你在不同的项目中保存不同的工作任务'},\n",
       "  {'from': 744.069, 'to': 747.189, 'location': 2, 'content': '一个项目包含工作文件夹'},\n",
       "  {'from': 747.189, 'to': 748.649, 'location': 2, 'content': '控制台内容'},\n",
       "  {'from': 748.649, 'to': 752.359, 'location': 2, 'content': '还可能包含一些关于项目的笔记'},\n",
       "  {'from': 752.359,\n",
       "   'to': 755.99,\n",
       "   'location': 2,\n",
       "   'content': '这样你就可以轻松地在不同任务之间切换'},\n",
       "  {'from': 755.99,\n",
       "   'to': 760.75,\n",
       "   'location': 2,\n",
       "   'content': '项目历史记录让你可以快速访问最近的项目'},\n",
       "  {'from': 760.97, 'to': 762.27, 'location': 2, 'content': '如果你保存了一个项目'},\n",
       "  {'from': 762.27,\n",
       "   'to': 766.05,\n",
       "   'location': 2,\n",
       "   'content': '默认情况下它会保存在应用程序目录中'},\n",
       "  {'from': 766.05, 'to': 766.89, 'location': 2, 'content': '可选择地'},\n",
       "  {'from': 766.89,\n",
       "   'to': 769.89,\n",
       "   'location': 2,\n",
       "   'content': '你可以将你的项目保存在任何其他地方'},\n",
       "  {'from': 770.53, 'to': 772.29, 'location': 2, 'content': '无论项目管理如何'},\n",
       "  {'from': 772.29,\n",
       "   'to': 775.65,\n",
       "   'location': 2,\n",
       "   'content': '你也可以使用窗口管理器设置你的环境'},\n",
       "  {'from': 775.65, 'to': 776.05, 'location': 2, 'content': '然而'},\n",
       "  {'from': 776.05, 'to': 779.17, 'location': 2, 'content': '你喜欢并保存了你最喜欢的设置'},\n",
       "  {'from': 780.499,\n",
       "   'to': 783.879,\n",
       "   'location': 2,\n",
       "   'content': '该应用程序可以在多种不同的语言下运行'},\n",
       "  {'from': 783.879, 'to': 787.87, 'location': 2, 'content': '默认语言在启动时检测'},\n",
       "  {'from': 787.87, 'to': 789.77, 'location': 2, 'content': '初始语言是英语'},\n",
       "  {'from': 789.77, 'to': 790.23, 'location': 2, 'content': '西班牙语'},\n",
       "  {'from': 790.23, 'to': 791.23, 'location': 2, 'content': '和德语'},\n",
       "  {'from': 791.23, 'to': 794.29, 'location': 2, 'content': '其他语言可能会跟随'},\n",
       "  {'from': 794.29, 'to': 798.25, 'location': 2, 'content': '笔记功能允许你将笔记保存到项目中'},\n",
       "  {'from': 798.43,\n",
       "   'to': 804.14,\n",
       "   'location': 2,\n",
       "   'content': '笔记可以格式化为普通文本或markdown表示法'},\n",
       "  {'from': 804.9,\n",
       "   'to': 811.16,\n",
       "   'location': 2,\n",
       "   'content': '所有llanol命令的执行都存储在本地sqlite数据库中'},\n",
       "  {'from': 811.16,\n",
       "   'to': 817.17,\n",
       "   'location': 2,\n",
       "   'content': '这给你提供了一个最近的操作概览以及查找之前参数设置的选项'},\n",
       "  {'from': 817.17, 'to': 819.35, 'location': 2, 'content': '你可以删除你不想要的条目'},\n",
       "  {'from': 819.35, 'to': 823.07, 'location': 2, 'content': '你也可以根据某些命令输入有关笔记'},\n",
       "  {'from': 823.07,\n",
       "   'to': 827.07,\n",
       "   'location': 2,\n",
       "   'content': '在线过滤功能可以让你快速高效地查找文件'},\n",
       "  {'from': 827.07, 'to': 828.15, 'location': 2, 'content': '命令'},\n",
       "  {'from': 828.15, 'to': 829.07, 'location': 2, 'content': '参数'},\n",
       "  {'from': 829.07, 'to': 832.96, 'location': 2, 'content': '或笔记'},\n",
       "  {'from': 832.96,\n",
       "   'to': 841.609,\n",
       "   'location': 2,\n",
       "   'content': '执行统计也提供了未来版本中自动任务规划和调度的选项'},\n",
       "  {'from': 841.609, 'to': 844.209, 'location': 2, 'content': '这些是laluk的基本功能'},\n",
       "  {'from': 844.209, 'to': 846.769, 'location': 2, 'content': 'laz工具的新gui工具'},\n",
       "  {'from': 846.769,\n",
       "   'to': 852.46,\n",
       "   'location': 2,\n",
       "   'content': '希望这个程序能使你用laz工具提高你的生产力'},\n",
       "  {'from': 852.46,\n",
       "   'to': 855.84,\n",
       "   'location': 2,\n",
       "   'content': '感谢观看这个视频并使用last工具工作'},\n",
       "  {'from': 855.84, 'to': 859.18, 'location': 2, 'content': '我们期待听到任何反馈和建议'},\n",
       "  {'from': 859.18, 'to': 860.4, 'location': 2, 'content': '你可能'}]}"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import json\n",
    "\n",
    "def read_bcc_file(file_path):\n",
    "    with open(file_path, 'r', encoding='utf-8') as file:\n",
    "        data = json.load(file)\n",
    "    return data\n",
    "\n",
    "# bcc文件路径\n",
    "bcc_file_path = \"sample.bcc\"\n",
    "bcc_data = read_bcc_file(bcc_file_path)\n",
    "\n",
    "bcc_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'from': 0.52, 'to': 3.36, 'location': 2, 'content': '欢迎来到laslook的介绍'},\n",
       " {'from': 3.36, 'to': 6.16, 'location': 2, 'content': 'laslook是lastools的新工具'},\n",
       " {'from': 6.16,\n",
       "  'to': 12.28,\n",
       "  'location': 2,\n",
       "  'content': '处理开放las或laz格式的点云数据的终极工具'},\n",
       " {'from': 12.28, 'to': 15.16, 'location': 2, 'content': '我们希望您了解什么是点云'},\n",
       " {'from': 15.16, 'to': 19.43, 'location': 2, 'content': '以及lastools的普遍可能性'},\n",
       " {'from': 19.43, 'to': 21.25, 'location': 2, 'content': '程序启动后'},\n",
       " {'from': 21.25, 'to': 23.22, 'location': 2, 'content': '您将看到主屏幕'},\n",
       " {'from': 23.22, 'to': 26.025, 'location': 2, 'content': '这更像是一个工作环境，而不是单一窗口'},\n",
       " {'from': 26.125,\n",
       "  'to': 30.75,\n",
       "  'location': 2,\n",
       "  'content': '在左上角，您将看到lastools的所有工具'},\n",
       " {'from': 30.75,\n",
       "  'to': 36.73,\n",
       "  'location': 2,\n",
       "  'content': '下方，我们提供了一个文件浏览器\\n您可快速了解正常处理的文件概况'},\n",
       " {'from': 36.73, 'to': 38.39, 'location': 2, 'content': '在文件浏览器下方'},\n",
       " {'from': 38.39, 'to': 42.79, 'location': 2, 'content': '提供了所选文件的快速预览'},\n",
       " {'from': 42.79,\n",
       "  'to': 45.709,\n",
       "  'location': 2,\n",
       "  'content': '在主工作区\\n提供了不同的模块的选项卡集合'},\n",
       " {'from': 45.709, 'to': 46.609, 'location': 2, 'content': '默认设置下'},\n",
       " {'from': 46.609, 'to': 53.43, 'location': 2, 'content': '可访问3D查看器、文档和参数查找器'},\n",
       " {'from': 53.43,\n",
       "  'to': 57.31,\n",
       "  'location': 2,\n",
       "  'content': '下方为执行区域、Console控制台窗口'},\n",
       " {'from': 57.31, 'to': 63.8, 'location': 2, 'content': '我们将从各个方面逐步介绍'},\n",
       " {'from': 63.8,\n",
       "  'to': 67.58,\n",
       "  'location': 2,\n",
       "  'content': '在工具列表中，您将看到每个工具及其单行描述'},\n",
       " {'from': 67.58, 'to': 69.9, 'location': 2, 'content': '选择工具将显示参数'},\n",
       " {'from': 69.9, 'to': 73.21, 'location': 2, 'content': '或所选工具在参数列中'},\n",
       " {'from': 73.21, 'to': 76.69, 'location': 2, 'content': '选择参数将显示该参数的参数'},\n",
       " {'from': 76.69, 'to': 79.86, 'location': 2, 'content': '并且可能会显示该参数的样本'},\n",
       " {'from': 79.86, 'to': 81.12, 'location': 2, 'content': '在两个窗口中'},\n",
       " {'from': 81.12,\n",
       "  'to': 85.88,\n",
       "  'location': 2,\n",
       "  'content': '您都有一个过滤字段，以递增方式过滤此列表中的项目'},\n",
       " {'from': 85.88, 'to': 91.76, 'location': 2, 'content': '此功能可让您快速了解可用的工具及其参数'},\n",
       " {'from': 91.76, 'to': 94.3, 'location': 2, 'content': '如果您想更详细地查看工具'},\n",
       " {'from': 94.3, 'to': 97.12, 'location': 2, 'content': '您可以简单地切换到工具文档'},\n",
       " {'from': 97.12, 'to': 102.47, 'location': 2, 'content': '查看工具文档将与所选工具同步'},\n",
       " {'from': 102.47,\n",
       "  'to': 106.89,\n",
       "  'location': 2,\n",
       "  'content': '您收到的信息您可能已经通过readme文件知道'},\n",
       " {'from': 106.89, 'to': 109.61, 'location': 2, 'content': '有一些额外的优势'},\n",
       " {'from': 109.61, 'to': 112.19, 'location': 2, 'content': '首先，我们有一个格式化的视图'},\n",
       " {'from': 112.19,\n",
       "  'to': 116.78,\n",
       "  'location': 2,\n",
       "  'content': 'readme的markdown被用于着色内容'},\n",
       " {'from': 116.78,\n",
       "  'to': 122.14,\n",
       "  'location': 2,\n",
       "  'content': '然后，我们可以使用标题结构来生成内容列表'},\n",
       " {'from': 122.14,\n",
       "  'to': 126.86,\n",
       "  'location': 2,\n",
       "  'content': '您可以单击内容条目以跳转到文件中的位置'},\n",
       " {'from': 126.86,\n",
       "  'to': 131.14,\n",
       "  'location': 2,\n",
       "  'content': '要么直接在编辑窗口中，要么在过滤字段中'},\n",
       " {'from': 131.14, 'to': 133.51, 'location': 2, 'content': '您可以输入搜索词'},\n",
       " {'from': 133.51, 'to': 136.97, 'location': 2, 'content': '此术语用于在当前文档中搜索'},\n",
       " {'from': 136.97, 'to': 139.73, 'location': 2, 'content': '以及所有道文档'},\n",
       " {'from': 139.73, 'to': 142.61, 'location': 2, 'content': '在文件中的高亮显示找到的位置'},\n",
       " {'from': 143.69,\n",
       "  'to': 148.13,\n",
       "  'location': 2,\n",
       "  'content': '在其他文件中的位置列出了全局结果列表'},\n",
       " {'from': 148.45, 'to': 152.92, 'location': 2, 'content': '使用f三或f四迭代匹配'},\n",
       " {'from': 152.92, 'to': 155.36, 'location': 2, 'content': '单击全局结果列'},\n",
       " {'from': 155.36, 'to': 158.82, 'location': 2, 'content': '在第一个位置打开所选文件'},\n",
       " {'from': 158.82, 'to': 162.26, 'location': 2, 'content': '但如果您不知道正在查找的参数'},\n",
       " {'from': 162.26, 'to': 165.36, 'location': 2, 'content': '或者哪个工具适合某个任务'},\n",
       " {'from': 165.36, 'to': 166.33, 'location': 2, 'content': '嗯'},\n",
       " {'from': 166.33,\n",
       "  'to': 170.73,\n",
       "  'location': 2,\n",
       "  'content': '我们为这个问题构建了一个全局参数数据库'},\n",
       " {'from': 170.73,\n",
       "  'to': 178.31,\n",
       "  'location': 2,\n",
       "  'content': '此数据库包含所有工具的所有参数以及它们的描述和可能的参数'},\n",
       " {'from': 178.31, 'to': 183.71, 'location': 2, 'content': '全球搜索框允许扫描所有参数和描述'},\n",
       " {'from': 183.71, 'to': 186.849, 'location': 2, 'content': '因此，如果您输入hp'},\n",
       " {'from': 186.849, 'to': 191.15, 'location': 2, 'content': '你将看到所有以hp作为参数的工具'},\n",
       " {'from': 191.15, 'to': 194.8, 'location': 2, 'content': '你也会看到这些参数属于哪个组'},\n",
       " {'from': 194.8,\n",
       "  'to': 199.579,\n",
       "  'location': 2,\n",
       "  'content': '如果你对以hp作为输出格式的工具感兴趣'},\n",
       " {'from': 199.579, 'to': 201.339, 'location': 2, 'content': '然后你选择单元格'},\n",
       " {'from': 201.339,\n",
       "  'to': 206.78,\n",
       "  'location': 2,\n",
       "  'content': '然后你会在工具列表中看到以绿色标记的工具'},\n",
       " {'from': 206.78, 'to': 208.16, 'location': 2, 'content': '通过选择组'},\n",
       " {'from': 208.16, 'to': 212.69, 'location': 2, 'content': '你可以独立过滤选定组的结果'},\n",
       " {'from': 212.97, 'to': 216.63, 'location': 2, 'content': '这个参数数据库加上工具文档'},\n",
       " {'from': 216.63,\n",
       "  'to': 222.235,\n",
       "  'location': 2,\n",
       "  'content': '给你提供了快速参考信息关于工具的能力'},\n",
       " {'from': 222.25, 'to': 225.45, 'location': 2, 'content': '但现在让我们来使用这些工具'},\n",
       " {'from': 225.45, 'to': 229.41, 'location': 2, 'content': '经典的laz工具是命令行工具'},\n",
       " {'from': 229.41, 'to': 232.47, 'location': 2, 'content': '因此我们集成了一个命令窗口'},\n",
       " {'from': 232.47,\n",
       "  'to': 236.329,\n",
       "  'location': 2,\n",
       "  'content': '你可能已经知道如何运行laz工具的命令'},\n",
       " {'from': 236.329, 'to': 237.269, 'location': 2, 'content': '原则上'},\n",
       " {'from': 237.269, 'to': 238.989, 'location': 2, 'content': '它仍然是完全相同的'},\n",
       " {'from': 238.989,\n",
       "  'to': 243.24,\n",
       "  'location': 2,\n",
       "  'content': '但我们想让你在构建命令文件时更有信心'},\n",
       " {'from': 243.24, 'to': 245.08, 'location': 2, 'content': '所以如果你想使用一条命令'},\n",
       " {'from': 245.08, 'to': 248.44, 'location': 2, 'content': '你只需通过工具列表双击它'},\n",
       " {'from': 248.64,\n",
       "  'to': 252.8,\n",
       "  'location': 2,\n",
       "  'content': '然后你需要从文件列表中双击你想要处理的数据文件'},\n",
       " {'from': 253.84,\n",
       "  'to': 257.94,\n",
       "  'location': 2,\n",
       "  'content': '然后你需要过滤并双击你想要使用的参数'},\n",
       " {'from': 259.21, 'to': 263.77, 'location': 2, 'content': '在这里你可以更改参数的默认值'},\n",
       " {'from': 265.12, 'to': 270.4, 'location': 2, 'content': '我们添加一个最后的命令并连接到文件'},\n",
       " {'from': 290.6,\n",
       "  'to': 298.78,\n",
       "  'location': 2,\n",
       "  'content': '最后你按f五来运行整个批次或者按控制返回来仅仅运行所选的命令'},\n",
       " {'from': 298.78, 'to': 300.74, 'location': 2, 'content': '进程将被启动'},\n",
       " {'from': 300.74, 'to': 303.46, 'location': 2, 'content': '一些新的执行线程将被打开'},\n",
       " {'from': 304.46,\n",
       "  'to': 310.06,\n",
       "  'location': 2,\n",
       "  'content': '在执行过程中，我们将为每个任务获得其自己的输出框'},\n",
       " {'from': 310.06, 'to': 312.04, 'location': 2, 'content': '你将看到工具的输出'},\n",
       " {'from': 313.32, 'to': 314.89, 'location': 2, 'content': '如果发生错误'},\n",
       " {'from': 314.89, 'to': 318.37, 'location': 2, 'content': '输出和编辑行将变成红色'},\n",
       " {'from': 318.37, 'to': 321.19, 'location': 2, 'content': '如果命令执行成功'},\n",
       " {'from': 321.19, 'to': 324.07, 'location': 2, 'content': '输出会变成绿色'},\n",
       " {'from': 324.55, 'to': 325.67, 'location': 2, 'content': '在我们的示例中'},\n",
       " {'from': 325.67, 'to': 326.71, 'location': 2, 'content': '我们收到了一个错误消息'},\n",
       " {'from': 326.71,\n",
       "  'to': 330.95,\n",
       "  'location': 2,\n",
       "  'content': '因为laz到laz没有创建不存在的输出路径'},\n",
       " {'from': 330.95, 'to': 332.29, 'location': 2, 'content': '这不是一个问题'},\n",
       " {'from': 332.29, 'to': 336.66, 'location': 2, 'content': '因为我们可以使用控制台创建这个路径'},\n",
       " {'from': 339.24,\n",
       "  'to': 344.49,\n",
       "  'location': 2,\n",
       "  'content': '所以laszuk是latools的工作台，适合测试命令，也适合日常工作'},\n",
       " {'from': 344.49, 'to': 346.53, 'location': 2, 'content': '以及你的自动化工作流'},\n",
       " {'from': 346.53, 'to': 348.87, 'location': 2, 'content': '如果你有自动化工作流'},\n",
       " {'from': 348.87,\n",
       "  'to': 352.46,\n",
       "  'location': 2,\n",
       "  'content': '在这里测试命令可能有用，以便运行它们'},\n",
       " {'from': 352.46, 'to': 355.3, 'location': 2, 'content': '你将继续使用你的经典命令文件'},\n",
       " {'from': 356.34,\n",
       "  'to': 359.58,\n",
       "  'location': 2,\n",
       "  'content': '这就是为什么你有一个选项可以保存你的控制台内容。'},\n",
       " {'from': 359.58, 'to': 360.68, 'location': 2, 'content': '对一个命令文件'},\n",
       " {'from': 360.68,\n",
       "  'to': 366.669,\n",
       "  'location': 2,\n",
       "  'content': '你可以通过对话给出一个名字，或者直接在第一行输入一个评论'},\n",
       " {'from': 366.669, 'to': 369.109, 'location': 2, 'content': '那个名字将被使用'},\n",
       " {'from': 370.14,\n",
       "  'to': 375.81,\n",
       "  'location': 2,\n",
       "  'content': '通常情况下，控制台传递机制会尝试并行处理你的任务。'},\n",
       " {'from': 375.81, 'to': 377.21, 'location': 2, 'content': '如果你不想要这个'},\n",
       " {'from': 377.21, 'to': 380.53, 'location': 2, 'content': '您只需点击顺序按钮'},\n",
       " {'from': 380.53, 'to': 381.05, 'location': 2, 'content': '转换'},\n",
       " {'from': 381.05, 'to': 381.59, 'location': 2, 'content': '逃脱'},\n",
       " {'from': 381.59,\n",
       "  'to': 386.159,\n",
       "  'location': 2,\n",
       "  'content': '或者点击“取消所有”来重置执行堆栈'},\n",
       " {'from': 386.159,\n",
       "  'to': 392.2,\n",
       "  'location': 2,\n",
       "  'content': '与控制台工作意味着总是与我们项目中的文件一起工作'},\n",
       " {'from': 392.24, 'to': 393.36, 'location': 2, 'content': '在左侧'},\n",
       " {'from': 393.36, 'to': 397.159, 'location': 2, 'content': '您将看到项目中所有文件'},\n",
       " {'from': 397.159, 'to': 400.199, 'location': 2, 'content': '这是一个集成的文件浏览器'},\n",
       " {'from': 400.199, 'to': 402.639, 'location': 2, 'content': '您可以通过点击选择文件'},\n",
       " {'from': 402.639,\n",
       "  'to': 408.28,\n",
       "  'location': 2,\n",
       "  'content': '鼠标滚轮或光标移动一旦您选择了文件'},\n",
       " {'from': 408.28, 'to': 413.72, 'location': 2, 'content': '文件信息窗口显示文件的初始预览'},\n",
       " {'from': 413.72,\n",
       "  'to': 419.03,\n",
       "  'location': 2,\n",
       "  'content': '最后文件以您在laz info中熟悉的方式显示'},\n",
       " {'from': 419.03, 'to': 421.13, 'location': 2, 'content': '文本文件以文本形式显示'},\n",
       " {'from': 421.13, 'to': 423.45, 'location': 2, 'content': '作为投手投掷时'},\n",
       " {'from': 423.45,\n",
       "  'to': 428.539,\n",
       "  'location': 2,\n",
       "  'content': '在任何情况下，您可以选择显示文件的十六进制内容'},\n",
       " {'from': 428.539, 'to': 430.099, 'location': 2, 'content': '预览支持'},\n",
       " {'from': 430.099, 'to': 434.519, 'location': 2, 'content': '如文本文件和常见图片格式'},\n",
       " {'from': 434.519, 'to': 437.659, 'location': 2, 'content': '浏览器与控制台同步'},\n",
       " {'from': 437.659, 'to': 440.079, 'location': 2, 'content': '一旦生成一个新的输出'},\n",
       " {'from': 440.079, 'to': 443.86, 'location': 2, 'content': '浏览器将在工具栏中显示此文件'},\n",
       " {'from': 443.86, 'to': 448.07, 'location': 2, 'content': '有几种方法可以更改目录'},\n",
       " {'from': 448.59, 'to': 450.27, 'location': 2, 'content': '显示目录历史'},\n",
       " {'from': 450.27, 'to': 451.47, 'location': 2, 'content': '过滤文件'},\n",
       " {'from': 451.47, 'to': 453.03, 'location': 2, 'content': '或者按名称排序'},\n",
       " {'from': 453.03, 'to': 455.419, 'location': 2, 'content': '尺寸或变更日期'},\n",
       " {'from': 455.419,\n",
       "  'to': 460.939,\n",
       "  'location': 2,\n",
       "  'content': '你可以隐藏你不想在列表中看到的文件，然后再次使它们可见'},\n",
       " {'from': 464.56, 'to': 467.52, 'location': 2, 'content': '现在我想向你展示三维查看器'},\n",
       " {'from': 467.52, 'to': 470.18, 'location': 2, 'content': '如果你在文件浏览器中选择了一个文件'},\n",
       " {'from': 470.18, 'to': 473.52, 'location': 2, 'content': '它也会出现在三维查看器中'},\n",
       " {'from': 473.659, 'to': 474.779, 'location': 2, 'content': '初次观看'},\n",
       " {'from': 474.779, 'to': 477.399, 'location': 2, 'content': '我们只读了文件中的一千多个点'},\n",
       " {'from': 477.399, 'to': 481.2, 'location': 2, 'content': '这个简单的技巧使得首次查看非常快速'},\n",
       " {'from': 481.2,\n",
       "  'to': 485.16,\n",
       "  'location': 2,\n",
       "  'content': '通常来看，只需查看一小部分你的数据就足够了'},\n",
       " {'from': 485.16, 'to': 489.1, 'location': 2, 'content': '评估点云或结果的质量'},\n",
       " {'from': 489.1, 'to': 490.9, 'location': 2, 'content': '如果你想查看所有点'},\n",
       " {'from': 490.9, 'to': 493.7, 'location': 2, 'content': '你只需点击显示所有数据'},\n",
       " {'from': 493.7, 'to': 498.069, 'location': 2, 'content': '对于每个文件，整个文件将加载'},\n",
       " {'from': 498.069, 'to': 500.869, 'location': 2, 'content': '你可以决定如何对点进行着色'},\n",
       " {'from': 500.869, 'to': 502.669, 'location': 2, 'content': '我将在样本上展示我们的瓷砖'},\n",
       " {'from': 502.669, 'to': 504.229, 'location': 2, 'content': '我们刚刚创建'},\n",
       " {'from': 504.92, 'to': 507.62, 'location': 2, 'content': '如果选择了按值着色'},\n",
       " {'from': 507.62, 'to': 510.16, 'location': 2, 'content': '还可以选择颜色方案'},\n",
       " {'from': 510.16, 'to': 513.69, 'location': 2, 'content': '颜色方案由用户配置'},\n",
       " {'from': 513.89,\n",
       "  'to': 520.059,\n",
       "  'location': 2,\n",
       "  'content': '此外，您可以更改点的大小和视图的背景'},\n",
       " {'from': 520.339, 'to': 523.839, 'location': 2, 'content': '视图方向通过鼠标修改最佳'},\n",
       " {'from': 523.839, 'to': 527.37, 'location': 2, 'content': '只需点击并移动以更改方向'},\n",
       " {'from': 527.37, 'to': 531.05, 'location': 2, 'content': '默认情况下，Z方向将向上固定'},\n",
       " {'from': 532.29, 'to': 532.99, 'location': 2, 'content': '按住Shift点击'},\n",
       " {'from': 532.99, 'to': 536.65, 'location': 2, 'content': '移动将使点云在XY平面内移动'},\n",
       " {'from': 536.65, 'to': 540.45, 'location': 2, 'content': '按住Ctrl点击将在Z平面内移动云'},\n",
       " {'from': 540.45,\n",
       "  'to': 545.3,\n",
       "  'location': 2,\n",
       "  'content': '右键移动将使您的观点中心移动到另一个位置'},\n",
       " {'from': 545.3,\n",
       "  'to': 551.47,\n",
       "  'location': 2,\n",
       "  'content': '这定义了您视图的缩放中心，缩放最好使用鼠标滚轮'},\n",
       " {'from': 551.47,\n",
       "  'to': 556.05,\n",
       "  'location': 2,\n",
       "  'content': '所有视图属性可以在三维控制面板中查看和更改'},\n",
       " {'from': 556.05,\n",
       "  'to': 561.5,\n",
       "  'location': 2,\n",
       "  'content': '更多像z缩放这样的属性可以通过控制面板实现'},\n",
       " {'from': 561.5, 'to': 562.32, 'location': 2, 'content': '此外'},\n",
       " {'from': 562.32, 'to': 565.74, 'location': 2, 'content': '您可以通过键盘轻松更改所有视图设置'},\n",
       " {'from': 565.74,\n",
       "  'to': 571.03,\n",
       "  'location': 2,\n",
       "  'content': '这里需要注意的一点是，数字键盘应设置为数字锁定关闭'},\n",
       " {'from': 571.03,\n",
       "  'to': 577.65,\n",
       "  'location': 2,\n",
       "  'content': '光标键会移动，加减号会缩放，Shift会减小步长'},\n",
       " {'from': 577.65,\n",
       "  'to': 583.35,\n",
       "  'location': 2,\n",
       "  'content': '控制光标会移动中心，斜杠会切换到顶部左视图，中心会重置视图'},\n",
       " {'from': 583.35, 'to': 587.14, 'location': 2, 'content': '一个独立的功能是同时显示多个文件'},\n",
       " {'from': 587.14, 'to': 592.16, 'location': 2, 'content': '一旦启用多视图选项'},\n",
       " {'from': 592.16, 'to': 595.08, 'location': 2, 'content': '文件将不自动同步'},\n",
       " {'from': 595.08, 'to': 598.66, 'location': 2, 'content': '您将看到每个文件旁边的视图图标'},\n",
       " {'from': 598.66, 'to': 602.16, 'location': 2, 'content': '如果我们想以视图显示此文件'},\n",
       " {'from': 602.16,\n",
       "  'to': 604.48,\n",
       "  'location': 2,\n",
       "  'content': '我们点击这个图标或在上下文菜单中选择该功能'},\n",
       " {'from': 604.48, 'to': 609.4, 'location': 2, 'content': '默认情况下'},\n",
       " {'from': 609.4, 'to': 610.56, 'location': 2, 'content': '所有文件都会居中显示，因为我们不知道'},\n",
       " {'from': 610.56, 'to': 614.16, 'location': 2, 'content': '文件是否有共同的范围基础'},\n",
       " {'from': 614.16, 'to': 616.59, 'location': 2, 'content': '您可以轻松地移动单个点云'},\n",
       " {'from': 616.59, 'to': 619.47, 'location': 2, 'content': '如我之前所示'},\n",
       " {'from': 619.47, 'to': 620.59, 'location': 2, 'content': '使用Shift点击移动'},\n",
       " {'from': 620.59, 'to': 622.41, 'location': 2, 'content': '如果我们知道或预期文件有共同的基础'},\n",
       " {'from': 622.41,\n",
       "  'to': 625.85,\n",
       "  'location': 2,\n",
       "  'content': '我们也可以取消选中居中并点击对齐自动'},\n",
       " {'from': 625.85, 'to': 630.99, 'location': 2, 'content': '文件将按原始位置对齐'},\n",
       " {'from': 630.99, 'to': 634.22, 'location': 2, 'content': '如果您迷失方向'},\n",
       " {'from': 634.22, 'to': 636.2, 'location': 2, 'content': '最好将所有数据集居中并重置您的相机'},\n",
       " {'from': 636.2, 'to': 640.92, 'location': 2, 'content': '很多时候您可能想探索数据中的详细信息'},\n",
       " {'from': 641.14,\n",
       "  'to': 644.8,\n",
       "  'location': 2,\n",
       "  'content': '我现在想向您展示我们如何轻松地做到这一点'},\n",
       " {'from': 644.8, 'to': 649.44, 'location': 2, 'content': '在查看器中'},\n",
       " {'from': 649.44, 'to': 650.56, 'location': 2, 'content': '我们总是以我们的视图中心工作'},\n",
       " {'from': 651.84, 'to': 654.63, 'location': 2, 'content': '这是你坐标轴运行的地方'},\n",
       " {'from': 654.63, 'to': 657.05, 'location': 2, 'content': '假设我们想检查这个绿色汽车'},\n",
       " {'from': 657.05, 'to': 660.01, 'location': 2, 'content': '例如'},\n",
       " {'from': 660.01, 'to': 660.85, 'location': 2, 'content': '所以首先我们切换到顶视图'},\n",
       " {'from': 660.85,\n",
       "  'to': 664.025,\n",
       "  'location': 2,\n",
       "  'content': '然后通过XY移动到我们目标的水平方心中'},\n",
       " {'from': 664.66, 'to': 668.68, 'location': 2, 'content': '使用右键移动'},\n",
       " {'from': 668.68, 'to': 671.5, 'location': 2, 'content': '然后稍微移动一下以查看当前的高度'},\n",
       " {'from': 671.78, 'to': 675.73, 'location': 2, 'content': '然后使用控制'},\n",
       " {'from': 675.73, 'to': 677.47, 'location': 2, 'content': '右键'},\n",
       " {'from': 677.47, 'to': 677.99, 'location': 2, 'content': '移动到我们目标的垂直中心'},\n",
       " {'from': 677.99,\n",
       "  'to': 681.65,\n",
       "  'location': 2,\n",
       "  'content': '现在我们可以轻松地放大目标并围绕它移动'},\n",
       " {'from': 682.15, 'to': 686.75, 'location': 2, 'content': '有时您可能想分离整个数据带'},\n",
       " {'from': 689.34, 'to': 692.74, 'location': 2, 'content': '可以通过激活截面功能来实现'},\n",
       " {'from': 692.74,\n",
       "  'to': 696.98,\n",
       "  'location': 2,\n",
       "  'content': '您可以使用鼠标定义截面或在编辑中输入尺寸'},\n",
       " {'from': 698.18, 'to': 704.98, 'location': 2, 'content': '点击独占以限制视图到平面'},\n",
       " {'from': 705.86, 'to': 709.4, 'location': 2, 'content': '您可以锁定平面并隐藏它们'},\n",
       " {'from': 709.4, 'to': 712.82, 'location': 2, 'content': '您可以使用中心按钮在平面前移动相机'},\n",
       " {'from': 714.06,\n",
       "  'to': 719.069,\n",
       "  'location': 2,\n",
       "  'content': '如果您更改颜色化参数或更改平面尺寸'},\n",
       " {'from': 719.869, 'to': 724.189, 'location': 2, 'content': '您可以在截面内重新计算数据'},\n",
       " {'from': 724.189, 'to': 727.469, 'location': 2, 'content': '这些是laluk的一些基本功能'},\n",
       " {'from': 728.22, 'to': 731.36, 'location': 2, 'content': '如果我们检查主菜单'},\n",
       " {'from': 731.36, 'to': 733.12, 'location': 2, 'content': '然而还有一些额外的功能'},\n",
       " {'from': 733.12, 'to': 736.63, 'location': 2, 'content': '首先'},\n",
       " {'from': 736.63, 'to': 738.17, 'location': 2, 'content': '我们有项目管理'},\n",
       " {'from': 738.17,\n",
       "  'to': 743.97,\n",
       "  'location': 2,\n",
       "  'content': '这个功能可以让你在不同的项目中保存不同的工作任务'},\n",
       " {'from': 744.069, 'to': 747.189, 'location': 2, 'content': '一个项目包含工作文件夹'},\n",
       " {'from': 747.189, 'to': 748.649, 'location': 2, 'content': '控制台内容'},\n",
       " {'from': 748.649, 'to': 752.359, 'location': 2, 'content': '还可能包含一些关于项目的笔记'},\n",
       " {'from': 752.359,\n",
       "  'to': 755.99,\n",
       "  'location': 2,\n",
       "  'content': '这样你就可以轻松地在不同任务之间切换'},\n",
       " {'from': 755.99,\n",
       "  'to': 760.75,\n",
       "  'location': 2,\n",
       "  'content': '项目历史记录让你可以快速访问最近的项目'},\n",
       " {'from': 760.97, 'to': 762.27, 'location': 2, 'content': '如果你保存了一个项目'},\n",
       " {'from': 762.27, 'to': 766.05, 'location': 2, 'content': '默认情况下它会保存在应用程序目录中'},\n",
       " {'from': 766.05, 'to': 766.89, 'location': 2, 'content': '可选择地'},\n",
       " {'from': 766.89, 'to': 769.89, 'location': 2, 'content': '你可以将你的项目保存在任何其他地方'},\n",
       " {'from': 770.53, 'to': 772.29, 'location': 2, 'content': '无论项目管理如何'},\n",
       " {'from': 772.29, 'to': 775.65, 'location': 2, 'content': '你也可以使用窗口管理器设置你的环境'},\n",
       " {'from': 775.65, 'to': 776.05, 'location': 2, 'content': '然而'},\n",
       " {'from': 776.05, 'to': 779.17, 'location': 2, 'content': '你喜欢并保存了你最喜欢的设置'},\n",
       " {'from': 780.499,\n",
       "  'to': 783.879,\n",
       "  'location': 2,\n",
       "  'content': '该应用程序可以在多种不同的语言下运行'},\n",
       " {'from': 783.879, 'to': 787.87, 'location': 2, 'content': '默认语言在启动时检测'},\n",
       " {'from': 787.87, 'to': 789.77, 'location': 2, 'content': '初始语言是英语'},\n",
       " {'from': 789.77, 'to': 790.23, 'location': 2, 'content': '西班牙语'},\n",
       " {'from': 790.23, 'to': 791.23, 'location': 2, 'content': '和德语'},\n",
       " {'from': 791.23, 'to': 794.29, 'location': 2, 'content': '其他语言可能会跟随'},\n",
       " {'from': 794.29, 'to': 798.25, 'location': 2, 'content': '笔记功能允许你将笔记保存到项目中'},\n",
       " {'from': 798.43,\n",
       "  'to': 804.14,\n",
       "  'location': 2,\n",
       "  'content': '笔记可以格式化为普通文本或markdown表示法'},\n",
       " {'from': 804.9,\n",
       "  'to': 811.16,\n",
       "  'location': 2,\n",
       "  'content': '所有llanol命令的执行都存储在本地sqlite数据库中'},\n",
       " {'from': 811.16,\n",
       "  'to': 817.17,\n",
       "  'location': 2,\n",
       "  'content': '这给你提供了一个最近的操作概览以及查找之前参数设置的选项'},\n",
       " {'from': 817.17, 'to': 819.35, 'location': 2, 'content': '你可以删除你不想要的条目'},\n",
       " {'from': 819.35, 'to': 823.07, 'location': 2, 'content': '你也可以根据某些命令输入有关笔记'},\n",
       " {'from': 823.07,\n",
       "  'to': 827.07,\n",
       "  'location': 2,\n",
       "  'content': '在线过滤功能可以让你快速高效地查找文件'},\n",
       " {'from': 827.07, 'to': 828.15, 'location': 2, 'content': '命令'},\n",
       " {'from': 828.15, 'to': 829.07, 'location': 2, 'content': '参数'},\n",
       " {'from': 829.07, 'to': 832.96, 'location': 2, 'content': '或笔记'},\n",
       " {'from': 832.96,\n",
       "  'to': 841.609,\n",
       "  'location': 2,\n",
       "  'content': '执行统计也提供了未来版本中自动任务规划和调度的选项'},\n",
       " {'from': 841.609, 'to': 844.209, 'location': 2, 'content': '这些是laluk的基本功能'},\n",
       " {'from': 844.209, 'to': 846.769, 'location': 2, 'content': 'laz工具的新gui工具'},\n",
       " {'from': 846.769,\n",
       "  'to': 852.46,\n",
       "  'location': 2,\n",
       "  'content': '希望这个程序能使你用laz工具提高你的生产力'},\n",
       " {'from': 852.46,\n",
       "  'to': 855.84,\n",
       "  'location': 2,\n",
       "  'content': '感谢观看这个视频并使用last工具工作'},\n",
       " {'from': 855.84, 'to': 859.18, 'location': 2, 'content': '我们期待听到任何反馈和建议'},\n",
       " {'from': 859.18, 'to': 860.4, 'location': 2, 'content': '你可能'}]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bcc_data['body']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "list"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(bcc_data[\"body\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(bcc_data[\"body\"][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>from</th>\n",
       "      <th>to</th>\n",
       "      <th>location</th>\n",
       "      <th>content</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.520</td>\n",
       "      <td>3.360</td>\n",
       "      <td>2</td>\n",
       "      <td>欢迎来到laslook的介绍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.360</td>\n",
       "      <td>6.160</td>\n",
       "      <td>2</td>\n",
       "      <td>laslook是lastools的新工具</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6.160</td>\n",
       "      <td>12.280</td>\n",
       "      <td>2</td>\n",
       "      <td>处理开放las或laz格式的点云数据的终极工具</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12.280</td>\n",
       "      <td>15.160</td>\n",
       "      <td>2</td>\n",
       "      <td>我们希望您了解什么是点云</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.160</td>\n",
       "      <td>19.430</td>\n",
       "      <td>2</td>\n",
       "      <td>以及lastools的普遍可能性</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>844.209</td>\n",
       "      <td>846.769</td>\n",
       "      <td>2</td>\n",
       "      <td>laz工具的新gui工具</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>846.769</td>\n",
       "      <td>852.460</td>\n",
       "      <td>2</td>\n",
       "      <td>希望这个程序能使你用laz工具提高你的生产力</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>852.460</td>\n",
       "      <td>855.840</td>\n",
       "      <td>2</td>\n",
       "      <td>感谢观看这个视频并使用last工具工作</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>855.840</td>\n",
       "      <td>859.180</td>\n",
       "      <td>2</td>\n",
       "      <td>我们期待听到任何反馈和建议</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>859.180</td>\n",
       "      <td>860.400</td>\n",
       "      <td>2</td>\n",
       "      <td>你可能</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>238 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        from       to  location                  content\n",
       "0      0.520    3.360         2           欢迎来到laslook的介绍\n",
       "1      3.360    6.160         2     laslook是lastools的新工具\n",
       "2      6.160   12.280         2  处理开放las或laz格式的点云数据的终极工具\n",
       "3     12.280   15.160         2             我们希望您了解什么是点云\n",
       "4     15.160   19.430         2         以及lastools的普遍可能性\n",
       "..       ...      ...       ...                      ...\n",
       "233  844.209  846.769         2             laz工具的新gui工具\n",
       "234  846.769  852.460         2   希望这个程序能使你用laz工具提高你的生产力\n",
       "235  852.460  855.840         2      感谢观看这个视频并使用last工具工作\n",
       "236  855.840  859.180         2            我们期待听到任何反馈和建议\n",
       "237  859.180  860.400         2                      你可能\n",
       "\n",
       "[238 rows x 4 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# 将 bcc_data['body'] 解析到 DataFrame 中\n",
    "df = pd.DataFrame(bcc_data[\"body\"])\n",
    "\n",
    "# 打印 DataFrame\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>from</th>\n",
       "      <th>to</th>\n",
       "      <th>location</th>\n",
       "      <th>content</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.520</td>\n",
       "      <td>3.360</td>\n",
       "      <td>2</td>\n",
       "      <td>欢迎来到laslook的介绍</td>\n",
       "      <td>00:00:00.52</td>\n",
       "      <td>00:00:03.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.360</td>\n",
       "      <td>6.160</td>\n",
       "      <td>2</td>\n",
       "      <td>laslook是lastools的新工具</td>\n",
       "      <td>00:00:03.36</td>\n",
       "      <td>00:00:06.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6.160</td>\n",
       "      <td>12.280</td>\n",
       "      <td>2</td>\n",
       "      <td>处理开放las或laz格式的点云数据的终极工具</td>\n",
       "      <td>00:00:06.16</td>\n",
       "      <td>00:00:12.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12.280</td>\n",
       "      <td>15.160</td>\n",
       "      <td>2</td>\n",
       "      <td>我们希望您了解什么是点云</td>\n",
       "      <td>00:00:12.28</td>\n",
       "      <td>00:00:15.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.160</td>\n",
       "      <td>19.430</td>\n",
       "      <td>2</td>\n",
       "      <td>以及lastools的普遍可能性</td>\n",
       "      <td>00:00:15.16</td>\n",
       "      <td>00:00:19.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>844.209</td>\n",
       "      <td>846.769</td>\n",
       "      <td>2</td>\n",
       "      <td>laz工具的新gui工具</td>\n",
       "      <td>00:14:04.21</td>\n",
       "      <td>00:14:06.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>846.769</td>\n",
       "      <td>852.460</td>\n",
       "      <td>2</td>\n",
       "      <td>希望这个程序能使你用laz工具提高你的生产力</td>\n",
       "      <td>00:14:06.77</td>\n",
       "      <td>00:14:12.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>852.460</td>\n",
       "      <td>855.840</td>\n",
       "      <td>2</td>\n",
       "      <td>感谢观看这个视频并使用last工具工作</td>\n",
       "      <td>00:14:12.46</td>\n",
       "      <td>00:14:15.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>855.840</td>\n",
       "      <td>859.180</td>\n",
       "      <td>2</td>\n",
       "      <td>我们期待听到任何反馈和建议</td>\n",
       "      <td>00:14:15.84</td>\n",
       "      <td>00:14:19.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>859.180</td>\n",
       "      <td>860.400</td>\n",
       "      <td>2</td>\n",
       "      <td>你可能</td>\n",
       "      <td>00:14:19.18</td>\n",
       "      <td>00:14:20.40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>238 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        from       to  location                  content   start_time  \\\n",
       "0      0.520    3.360         2           欢迎来到laslook的介绍  00:00:00.52   \n",
       "1      3.360    6.160         2     laslook是lastools的新工具  00:00:03.36   \n",
       "2      6.160   12.280         2  处理开放las或laz格式的点云数据的终极工具  00:00:06.16   \n",
       "3     12.280   15.160         2             我们希望您了解什么是点云  00:00:12.28   \n",
       "4     15.160   19.430         2         以及lastools的普遍可能性  00:00:15.16   \n",
       "..       ...      ...       ...                      ...          ...   \n",
       "233  844.209  846.769         2             laz工具的新gui工具  00:14:04.21   \n",
       "234  846.769  852.460         2   希望这个程序能使你用laz工具提高你的生产力  00:14:06.77   \n",
       "235  852.460  855.840         2      感谢观看这个视频并使用last工具工作  00:14:12.46   \n",
       "236  855.840  859.180         2            我们期待听到任何反馈和建议  00:14:15.84   \n",
       "237  859.180  860.400         2                      你可能  00:14:19.18   \n",
       "\n",
       "        end_time  \n",
       "0    00:00:03.36  \n",
       "1    00:00:06.16  \n",
       "2    00:00:12.28  \n",
       "3    00:00:15.16  \n",
       "4    00:00:19.43  \n",
       "..           ...  \n",
       "233  00:14:06.77  \n",
       "234  00:14:12.46  \n",
       "235  00:14:15.84  \n",
       "236  00:14:19.18  \n",
       "237  00:14:20.40  \n",
       "\n",
       "[238 rows x 6 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from datetime import timedelta\n",
    "\n",
    "def seconds_to_time_string(seconds):\n",
    "    # 将秒数转换为 timedelta 对象\n",
    "    time_delta = timedelta(seconds=seconds)\n",
    "\n",
    "    # 使用 strftime 方法将 timedelta 对象格式化为字符串，并保留两位小数\n",
    "    time_string = time_delta.total_seconds()\n",
    "    time_string = \"{:.2f}\".format(time_string)\n",
    "\n",
    "    # 将秒数部分替换为 HH:MM:SS 格式\n",
    "    hours, remainder = divmod(int(time_string.split(\".\")[0]), 3600)\n",
    "    minutes, seconds = divmod(remainder, 60)\n",
    "    time_string = f\"{hours:02d}:{minutes:02d}:{seconds:02d}.{time_string.split('.')[1]}\"\n",
    "\n",
    "    return time_string\n",
    "\n",
    "# 换算为Aegisub时间格式\n",
    "df.loc[:, \"start_time\"] = df[\"from\"].apply(lambda x: seconds_to_time_string(x))\n",
    "df.loc[:, \"end_time\"] = df[\"to\"].apply(lambda x: seconds_to_time_string(x))\n",
    "\n",
    "# 将 content 字段中的 \\n 替换为 \\\\N\n",
    "df[\"content\"] = df[\"content\"].str.replace(\"\\n\", \"\\\\N\")\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将 DataFrame 转换为 ASS 文件格式\n",
    "def df_to_ass(df):\n",
    "    # 文件抬头\n",
    "    ass_content = \"[Script Info]\\n\"\n",
    "    ass_content += \"ScriptType: v4.00+\\n\"\n",
    "    ass_content += \"PlayResX: 1920\\n\"\n",
    "    ass_content += \"PlayResY: 1080\\n\"\n",
    "    ass_content += \"WrapStyle: 0\\n\"\n",
    "    ass_content += \"\\n\"\n",
    "    ass_content += \"[V4+ Styles]\\n\"\n",
    "    # 样式设置\n",
    "    ass_content += \"Format: Name, Fontname, Fontsize, PrimaryColour, SecondaryColour, OutlineColour, BackColour, Bold, Italic, Underline, StrikeOut, ScaleX, ScaleY, Spacing, Angle, BorderStyle, Outline, Shadow, Alignment, MarginL, MarginR, MarginV, Encoding\\n\"\n",
    "    ass_content += \"Style: Default,Arial,36,&H00FFFFFF,&H000000FF,&H00000000,&H00000000,0,0,0,0,100,100,0,0,1,2,2,2,10,10,10,0\\n\"\n",
    "    ass_content += \"\\n\"\n",
    "    # 字幕内容\n",
    "    ass_content += \"[Events]\\n\"\n",
    "    ass_content += (\n",
    "        \"Format: Layer, Start, End, Style, Name, MarginL, MarginR, MarginV, Effect, Text\\n\"\n",
    "    )\n",
    "    \n",
    "    # 逐行写入\n",
    "    for index, row in df.iterrows():\n",
    "        ass_content += (\n",
    "            f\"Dialogue: 0,{row['start_time']},{row['end_time']},Default,,0,0,0,,{row['content']}\\n\"\n",
    "        )\n",
    "\n",
    "    return ass_content\n",
    "\n",
    "\n",
    "# 将 DataFrame 转换为 ASS 文件内容\n",
    "ass_file_content = df_to_ass(df)\n",
    "\n",
    "# 将 ASS 文件内容写入文件\n",
    "with open(\"output.ass\", \"w\", encoding=\"utf-8\") as file:\n",
    "    file.write(ass_file_content)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "dash",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.19"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}