对于下面的示例,我必须将pandas系列的每个字段分配给类实例
有没有什么方法可以在一个步骤中做到这一点(比如:abc = Abc(series)
import pandas as pd
from sqlalchemy import Column, Integer, String, Boolean
from sqlalchemy.dialects.mysql import DATETIME
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Abc(Base):
__tablename__ = 'abc'
runId = Column(Integer, primary_key=True)
runComment = Column(String(255))
dateTimeProcessed = Column(DATETIME(fsp=6))
status = Column(Boolean, nullable=False)
df = pd.DataFrame({"runId": [1, 2, 3], "runComment": [4, 5, 6],"dateTimeProcessed": [1, 2, 3], "status": [1, 2, 3], })
series = df.iloc[0]
abc = Abc(runId=series.runId,
runComment=series.runComment,
dateTimeProcessed=series.dateTimeProcessed,
status=series.status)
pandas.Series
对象是映射,您可以使用关键字参数解包,即“双splat”:相关问题 更多 >
编程相关推荐