# Ignore CSV comments in a DataFrame

**URL:** https://discourse.julialang.org/t/ignore-csv-comments-in-a-dataframe/26785
**Category:** General Usage
**Created:** [July 25, 2019, 8:55am UTC](https://discourse.julialang.org/t/ignore-csv-comments-in-a-dataframe/26785 "2019-07-25T08:55:56Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![MuadhF](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/muadhf/32/20389_2.png) [@MuadhF](https://discourse.julialang.org/u/MuadhF)
#### Post date: [July 25, 2019, 8:55am UTC](https://discourse.julialang.org/t/ignore-csv-comments-in-a-dataframe/26785/1 "2019-07-25T08:55:56Z")

</div>

Hi,

I’ve noticed that when creating a DataFrame using a CSV file, it registers comments as `missing`. For example, a section of my CSV file is

“Annual Interest Rate, 0.08  
#ignore this”

but when I create the DataFrame as follows,

```julia
using CSV

q = CSV.File("C:\\Users\\Muadh\\.atom\\input_1.csv"; comment = "#", delim = ",") |> DataFrame

```

the DataFrame adds the extra row and is registered as a missing value. I know that `readtable` function allows comments, but I get warned that it’s a deprecated method. Is there any other possible way for the comment to be completely ignored?

Thanks!

---

<div class="post-metadata">

### Author: ![quinnj](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/quinnj/32/11_2.png) [@quinnj](https://discourse.julialang.org/u/quinnj)
#### Post date: [July 26, 2019, 3:14am UTC](https://discourse.julialang.org/t/ignore-csv-comments-in-a-dataframe/26785/2 "2019-07-26T03:14:12Z")

</div>

Can you share the full file? Even if just privately with me? Happy to take a look at what’s going on here and fix it if there’s a problem. `readtable` is definitely going away soon, so we want to make sure CSV.jl is fully ready to handle any cases from that.