# Load CSV File with Logstash and mutate fields in numbers
**URL:** https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427
**Category:** Logstash
**Created:** [November 12, 2015, 2:58pm UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427 "2015-11-12T14:58:48Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@adellarocca](https://discuss.elastic.co/u/adellarocca)
#### Post date: [November 12, 2015, 2:58pm UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427/1 "2015-11-12T14:58:48Z")
Hi!
I'm trying to import a csv file with logstash.
I've used csv filter but I need to convert some fields types in float.
This is my conf file
input{
```
file {
path => "/home/alessandro/Scrivania/dataset/aft_air_data_small.csv"
start_position => beginning
}
```
}
filter {
```
csv {
columns => [
"YEAR",
"AIRLINE_ID",
"FL_NUM",
"ORIGIN_AIRPORT_ID",
"ORIGIN",
"ORIGIN_CITY_NAME",
"ORIGIN_STATE_ABR",
"ORIGIN_STATE_NM",
"DEST_AIRPORT_ID",
"DEST",
"DEST_CITY_NAME",
"DEST_STATE_ABR",
"CRS_DEP_TIME",
"DEP_TIME",
"DEP_DELAY",
"CRS_ARR_TIME",
"ARR_TIME",
"ARR_DELAY",
"CANCELLED",
"AIR_TIME"
]
separator => ","
remove_field => ["YEAR", "CRS_DEP_TIME", "CRS_ARR_TIME"]
}
mutate {
convert => {
"DEP_DELAY" => "float"
"ARR_DELAY" => "float"
"AIR_TIME" => "float"
}
}
```
}
output {
elasticsearch {
```
hosts => ["localhost:9200"]
action => "index"
index => "aft_air_cont_index"
}
```
Are there errors? Thank you at all!
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [November 12, 2015, 7:38pm UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427/2 "2015-11-12T19:38:06Z")
You configuration looks okay. What's the problem? Can you give us example input and the output you get?
---
### Author:  [@adellarocca](https://discuss.elastic.co/u/adellarocca)
#### Post date: [November 13, 2015, 10:22am UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427/3 "2015-11-13T10:22:04Z")
Thank you for your support!
I've resolved. My csv file was malformed.
Thank you!
---
### Author:  [@amran1](https://discuss.elastic.co/u/amran1)
#### Post date: [September 1, 2016, 5:04am UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427/4 "2016-09-01T05:04:49Z")
Hi,
I tried this one but I with Longitude and Latitude as a location
But I couldn't generate tile map, any help?
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [September 1, 2016, 5:31am UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427/5 "2016-09-01T05:31:20Z")
@amran1, please start your own thread for your unrelated question (and when you do, please include more details about your configuration, what your input file looks like, etc).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 4:40am UTC](https://discuss.elastic.co/t/load-csv-file-with-logstash-and-mutate-fields-in-numbers/34427/6 "2017-07-06T04:40:33Z")