# Question about my data

**URL:** <https://discourse.julialang.org/t/question-about-my-data/44237>\
**Category:** General Usage\
**Tags:** question\
**Created:** [August 4, 2020, 8:06am UTC](https://discourse.julialang.org/t/question-about-my-data/44237 "2020-08-04T08:06:50Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![abcde](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/abcde/32/16180_2.png) [@abcde](https://discourse.julialang.org/u/abcde)\
**Post date:** [August 4, 2020, 10:00am UTC](https://discourse.julialang.org/t/question-about-my-data/44237/21 "2020-08-04T10:00:51Z")

</div>

i saw it!

---

<div class="post-metadata">

**Author:** ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)\
**Post date:** [August 4, 2020, 10:01am UTC](https://discourse.julialang.org/t/question-about-my-data/44237/22 "2020-08-04T10:01:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![abcde](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/abcde/32/16180_2.png) [@abcde](https://discourse.julialang.org/u/abcde)\
**Post date:** [August 4, 2020, 10:13am UTC](https://discourse.julialang.org/t/question-about-my-data/44237/23 "2020-08-04T10:13:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)\
**Post date:** [August 4, 2020, 10:20am UTC](https://discourse.julialang.org/t/question-about-my-data/44237/24 "2020-08-04T10:20:58Z")

</div>

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.

[Previous page](https://discourse.julialang.org/t/question-about-my-data/44237.md?page=1)
