为什么下面的行生成一维数组而不是二维数组?



我正在尝试读取Julia 1.1的CSV文件,生成与csv文件中原始数据布局相同的字符串矩阵。换句话说,如果我的 CSV 文件是

a,s,d,f,g,h
q,w,e,r,t,y

我的矩阵应该看起来像

a s d f g h
q w e r t y

我不知道文件中有多少行,所以我尝试了以下操作:

csv_file_lines = readlines("./" * filename)
data = hcat( map( x -> split(x, ","), csv_file_lines ) )

在我的一个较短的示例文件中,输出是

Array{SubString{String},1}[["date", "watch_time_minutes", "views", "average_view_duration", "video_thumbnail_impressions", "video_thumbnail_impressions_ctr"]; ["2019-03-04", "83.2051", "28", "2.9716", "318", "6.2893"]; ["2019-03-05", "43.6223", "12", "3.6352", "79", "10.1266"]; ["2019-03-06", "5.5267", "2", "2.7633", "33", "6.0606"]; ["2019-03-07", "0", "0", "0", "0", "0"]; ["2019-03-08", "58.7133", "11", "5.3376", "86", "8.1395"]; ["2019-03-09", "0", "0", "0", "0", "0"]; ["2019-03-10", "20.205", "4", "5.0512", "14", "7.1429"]; ["2019-03-11", "10.7013", "4", "2.6753", "24", "4.1667"]; ["2019-03-12", "1.3", "1", "1.3", "5", "20"]; ["2019-03-13", "0", "0", "0", "0", "0"]; ["2019-03-14", "14.7383", "6", "2.4564", "65", "9.2308"]; ["2019-03-15", "20.75", "7", "2.9643", "25", "12"]; ["2019-03-16", "31.0083", "4", "7.7521", "0", ""]; ["2019-03-17", "6.8624", "2", "3.4312", "0", ""]; ["2019-03-18", "0", "0", "0", "0", "0"]; ["2019-03-19", "0", "0", "0", "0", "0"]; ["2019-03-20", "0", "0", "0", "0", "0"]; ["2019-03-21", "0", "0", "0", "0", "0"]]

它是Substring数组的一维数组,而不是Strings(或本例中为Substrings)的二维数组。我在这里做错了什么?将hcat更改为vcat无助于缓解此问题。

编辑

我宁愿在没有CSV包或数据帧的情况下执行此操作,以减少开销。

我认为标准库DelimitFiles中的readdlm是您要查找的:

julia> using DelimitedFiles
julia> readdlm("file.csv", ',', String)
2×6 Array{String,2}:
"a"  "s"  "d"  "f"  "g"  "h"
"q"  "w"  "e"  "r"  "t"  "y"

这将生成一个2x6字符串矩阵。

有关详细信息,请查看?readdlm

最新更新