Hosuke

import os
import re

# Get the current working directory
directory = os.getcwd()

# Iterate over all files in the directory and its subdirectories
for dirpath, dirnames, filenames in os.walk(directory):
    for filename in filenames:
        # Process only files with a .sql extension

Hosuke

import pandas as pd
import yaml

# 读取CSV文件
df = pd.read_csv('dex_base_trades_seed.csv')

# 初始化schema字典
schema = {
    "version": 2,
    "seeds": []

Hosuke

import pandas as pd

if __name__ == '__main__':

    # Reload the CSV file due to code execution state reset
    file_path = '01HKPMHCEM0TFYD6KNPM66XHTT.csv'
    df = pd.read_csv(file_path)

    # Construct the SQL query in the desired format with dynamic field names
    sql_query = "SELECT "

Hosuke

import json
import requests
import pandas as pd

def get_coinpaprika_data():
    # Get data from coinpaprika
    url = "https://api.coinpaprika.com/v1/coins/"
    response = requests.get(url)
    return response.json()