# Loading .csv into a DataFrame with missing insertion and column-type correction (one-linerish)

**URL:** https://discourse.julialang.org/t/loading-csv-into-a-dataframe-with-missing-insertion-and-column-type-correction-one-linerish/60088
**Category:** Data
**Tags:** dataframes, csv
**Created:** [April 27, 2021, 8:35am UTC](https://discourse.julialang.org/t/loading-csv-into-a-dataframe-with-missing-insertion-and-column-type-correction-one-linerish/60088 "2021-04-27T08:35:46Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![egolep](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/egolep/32/23498_2.png) [@egolep](https://discourse.julialang.org/u/egolep)
#### Post date: [April 27, 2021, 9:02am UTC](https://discourse.julialang.org/t/loading-csv-into-a-dataframe-with-missing-insertion-and-column-type-correction-one-linerish/60088/2 "2021-04-27T09:02:36Z")

</div>

I finally found the missingstring and missingstrings parameters for CSV.File

It completely solves the problem with:

df = CSV.File(“filename.csv”, missingstring=“NA”) |\> DataFrame

if there are more than one string replacing the missing values, it’s:

df = CSV.File(“filename.csv”, missingstrings=[“string1”, “string2”) |\> DataFrame

hope this can help someone else coming from Python

---

_[View the full topic](https://discourse.julialang.org/t/loading-csv-into-a-dataframe-with-missing-insertion-and-column-type-correction-one-linerish/60088)._