Importing csv through machine learning

Elastic Stack Elasticsearch
1

Hi,

I have a csv with two columns. one having date in the format
2019/04/30 Tuesday 08:00:00 and second column a float value

So i have created mappings like below:
'''
PUT /lt_ts1
{
"mappings": {
"properties": {
"rec_date": {
"type": "date",
"format": "yyyy/MM/dd EEEE HH:mm:ss"},
"Load in kW": { "type": "float"}
}
}
}
'''
here lt_ts1 is the index name.

Now how should i bind these mappings to the csv file through machine learning. I have chosen machine learning ecause in python client i am not able to create a elasticsearch object since the converting the string to above date format is not available.

2

After I executed PUT I could see "lt_ts1" index in the Elasticsearch Index Management but in the Kibana Index patterns and in the Visualiations it is not shown.

Please guide me