Python 如何将 pandas 数据帧提交到 JSONutf8 返回到 gitlab，以便将其读取为 CSV

很有可能，由于某些编码问题，您的.csv文件无法识别.要解决此问题，您可以通过base64 module使用Base64编码对文件进行编码.

以下是如何使用pandas和github将您提供的文件内容上载到选定存储库的工作示例:

import pandas as pd
import base64
import requests
import json

url = "https://gitlab.com/datasets_a/mpg-data/-/raw/master/mpg.csv"
# Reading URL data
data_orig = pd.read_csv(url, index_col=0)

# Convert the DataFrame to a CSV string
csv_str = data_orig.to_csv(index=False)

# Encode the CSV string as base64
base64_content = base64.b64encode(csv_str.encode('utf-8')).decode('utf-8')

headers = {
    "Authorization": "Bearer  <YOUR TOKEN>",
    "Accept": "application/vnd.github.v3+json"
}

# Create the request payload
payload = {
    "message": "add new csv file",
    "content": base64_content,
    "branch": "main"
}

# Convert the payload to JSON
json_payload = json.dumps(payload)

# Send the request to create the file
response = requests.put(<REQUEST URL>, headers=headers, data=json_payload)

所得到的文件被上载到玩具储存库here.

通过将操作的encoding属性设置为base64(参见documentation)，您应该能够实现相同的VIA gitlab，如下所示:

data = {
        'branch': 'main',
        'commit_message': Time,
        'actions': [
        {
                'action': 'update',
                'file_path': filename,
                'content': base64_content,
                'encoding': 'base64'
        }
        ]
}

希望这能有所帮助.