i saw it!
The problem is in those empty cells - they contain a whitespace character that should be deleted. After deleting this whitespace, CSV will read those cells in as missing, and you’ll end up with Union{Float64, Missing} columns in your DataFrame
it works,thanks!There is a problem, that is, in a DataFrame format file can’t change the shape of the data, also is cannot reshape
It’s not clear what the problem is - what do you mean by reshape? You can aggregate (as I showed above, going from hours to days) or “reshape” in the sense of long-to-wide, but ultimately a DataFrame is of course a tabular (2D) data format, so if you’re after some more complex data layout it might not be the right choice for your problem.
2 Likes