# How to load CSV file at Jupyterlab

**URL:** <https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501>\
**Category:** New to Julia\
**Tags:** question\
**Created:** [September 7, 2019, 2:07pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501 "2019-09-07T14:07:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![hasanOryx](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/hasanoryx/32/5373_2.png) [@hasanOryx](https://discourse.julialang.org/u/hasanOryx)\
**Post date:** [September 7, 2019, 2:07pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/1 "2019-09-07T14:07:26Z")

</div>

I’m trying both file reading and Jupyter for the first time, and need to try opening, reading and amending (writing back) to `csv` file, can any one provide or guide me for an example/tutorial to start with. thanks

---

<div class="post-metadata">

**Author:** ![xiaodai](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/xiaodai/32/15937_2.png) [@xiaodai](https://discourse.julialang.org/u/xiaodai)\
**Post date:** [September 7, 2019, 2:17pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/2 "2019-09-07T14:17:38Z")

</div>

Can’t help you with Jupyter but just use `CSV.jl`

```julia
using CSV
df = CSV.read(filepath)

```

---

<div class="post-metadata">

**Author:** ![hasanOryx](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/hasanoryx/32/5373_2.png) [@hasanOryx](https://discourse.julialang.org/u/hasanOryx)\
**Post date:** [September 7, 2019, 2:48pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/3 "2019-09-07T14:48:20Z")

</div>

Thanks, it worked with Jupyter in same way.

mm, how can I write to it, I did not get it from the `CSV` package tutorial

---

<div class="post-metadata">

**Author:** ![xiaodai](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/xiaodai/32/15937_2.png) [@xiaodai](https://discourse.julialang.org/u/xiaodai)\
**Post date:** [September 7, 2019, 2:49pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/4 "2019-09-07T14:49:56Z")

</div>

`CSV.write(write_path, data_frame)`

---

<div class="post-metadata">

**Author:** ![hasanOryx](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/hasanoryx/32/5373_2.png) [@hasanOryx](https://discourse.julialang.org/u/hasanOryx)\
**Post date:** [September 7, 2019, 2:57pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/5 "2019-09-07T14:57:07Z")

</div>

This completely replaced the old contents, I need to add to it, sorry I did not mention this note in my reply before.

---

<div class="post-metadata">

**Author:** ![kevbonham](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/kevbonham/32/216165_2.png) [@kevbonham](https://discourse.julialang.org/u/kevbonham)\
**Post date:** [September 7, 2019, 3:59pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/6 "2019-09-07T15:59:28Z")

</div>

`append=true`? [See here](https://juliadata.github.io/CSV.jl/v0.1.1/#CSV.write)

---

<div class="post-metadata">

**Author:** ![hasanOryx](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/hasanoryx/32/5373_2.png) [@hasanOryx](https://discourse.julialang.org/u/hasanOryx)\
**Post date:** [September 7, 2019, 4:09pm UTC](https://discourse.julialang.org/t/how-to-load-csv-file-at-jupyterlab/28501/7 "2019-09-07T16:09:14Z")

</div>

> [@kevbonham](#):
>
> append=true

Thanks a lot, worked perfectly