import nbformat
from nbconvert import PythonExporter

# 讀取 Jupyter notebook 文件
notebook_filename = 'Builddata.ipynb'  # 替換為你的 .ipynb 文件路徑
with open(notebook_filename, 'r', encoding='utf-8') as notebook_file:
    notebook_content = nbformat.read(notebook_file, as_version=4)

# 使用 PythonExporter 將 notebook 轉(zhuǎn)換為 Python 腳本
python_exporter = PythonExporter()
python_code, _ = python_exporter.from_notebook_node(notebook_content)

# 將 Python 代碼寫入 .py 文件
python_filename = notebook_filename.replace('.ipynb', '.py')
with open(python_filename, 'w', encoding='utf-8') as python_file:
    python_file.write(python_code)

print(f'Notebook converted to Python script: {python_filename}')

import sqlite3
import csv

# 你的CSV文件路徑
csv_file = '202103_LD.csv'

# 轉(zhuǎn)成SQLite數(shù)據(jù)庫文件路徑
db_file = '202103_LD.db'

# 連接SQLite數(shù)據(jù)庫（如果數(shù)據(jù)庫文件不存在，它會被自動創(chuàng)建）
conn = sqlite3.connect(db_file)
cursor = conn.cursor()

# 讀取CSV文件并獲取列名
with open(csv_file, mode='r', newline='', encoding='utf-8') as file:
    reader = csv.reader(file)
    headers = next(reader)  # 獲取第一行（標(biāo)簽行）

    # 動態(tài)創(chuàng)建SQL表語句 data為表名
    columns = ', '.join([f"{header} TEXT" for header in headers])
    create_table_sql = f"CREATE TABLE IF NOT EXISTS data ({columns})"
    cursor.execute(create_table_sql)

    # 插入數(shù)據(jù)
    for row in reader:
        placeholders = ', '.join(['?' for _ in headers])
        insert_sql = f"INSERT INTO data ({', '.join(headers)}) VALUES ({placeholders})"
        cursor.execute(insert_sql, row)

# 提交事務(wù)并關(guān)閉連接
conn.commit()
conn.close()

print(f"數(shù)據(jù)成功從CSV文件導(dǎo)入到數(shù)據(jù)庫 {db_file} 中！")

import csv
import json

csv_file = 'data.csv'
json_file = 'data.json'

# 讀取CSV文件
with open(csv_file, mode='r', newline='', encoding='utf-8') as csvf:
    reader = csv.DictReader(csvf)
    data = [row for row in reader]

# 寫入JSON文件
with open(json_file, 'w', encoding='utf-8') as jsonf:
    json.dump(data, jsonf, ensure_ascii=False, indent=4)

import json
import csv

json_file = 'data.json'
csv_file = 'data.csv'

# 讀取JSON文件
with open(json_file, 'r', encoding='utf-8') as jf:
    data = json.load(jf)

# 寫入CSV文件
with open(csv_file, mode='w', newline='', encoding='utf-8') as cf:
    writer = csv.DictWriter(cf, fieldnames=data[0].keys())
    writer.writeheader()
    writer.writerows(data)