我试图将测试数据从CSV文件加载到可以加载到内存中的EF上下文中的记录中。
我有一个简化的实体,看起来像:
public class Project
{
public int { get; set; }
public Owner? Owner { get; set; } = null;
}
类图:
public class ProjectsClassMap : CsvHelper.Configuration.ClassMap<Projects>
{
public ProjectsClassMap()
{
AutoMap(Culture
我想将.csv.zst加载到数据文件中:
for ex in examples:
path = root + "f=" + ex + "/" + date
data = os.listdir(path)
for d in data:
zst_datapath = path + "/" + d
with open(zst_datapath, 'rb') as fh:
data = fh.read()
dctx = zst
我的演示数据库里有张桌子。
CREATE TABLE airports_data (
airport_code character(3) NOT NULL,
airport_name text NOT NULL,
city text NOT NULL,
coordinates super NOT NULL,
timezone text NOT NULL
);
在Postgres数据库中,坐标列中的数据点为数据类型,如下所示:
{"x":129.77099609375,"y":62.093299865722656}
提取到数据框中的API数据在几个注释单元格中包含空值。我最终希望将数据帧加载到csv文件中。当我将数据帧加载到csv时,注释中的空行被视为新行,因此在csv中给出了错误的行数。
数据帧:
Employee_id | Employeee_comments
---------------------------------------
1 | 1. This is test comment 1
| 2. This is test comment 2
|
| Comments above employee a
项目lib文档展示了如何将pandas数据帧保存到项目资产中:
# Import the lib
from project_lib import Project
project = Project(sc,"<ProjectId>", "<ProjectToken>")
# let's assume you have the pandas DataFrame pandas_df which contains the data
# you want to save in your object storage as