我对docker很陌生。我正在使用docker和pandas读取csv文件并插入数据库。
Dockerfile(码头文件):
FROM python:3.8
ADD main.py .
RUN pip install requests pandas sqlalchemy
CMD ["python","./main.py"]
主要.py:
进口
import pandas as pd
from sqlalchemy import create_engine
# This CSV doesn't have a header so pass
# column names as an argument
columns = [
"open",
"high",
"low",
"close",
"volume",
"datetime",
]
# Load in the data
df = pd.read_csv(r"/Users/myname/Downloads/file511282022.csv",names=columns)
# Instantiate sqlachemy.create_engine object
engine = create_engine('postgresql://postgres:mypassword@localhost:5432/postgres')
# Save the data from dataframe to
# postgres table "iris_dataset"
df.to_sql(
'file5',
engine,
# index=False # Not copying over the index
)
错误:
FileNotFoundError: [Errno 2] No such file or directory: '/Users/myname/Downloads/file511282022.csv'
pd.readcsv代码在jupter笔记本中的docker中运行,代码相同:
pd.read_csv(r"/Users/myname/Downloads/file511282022.csv",names=columns)