Importing csv through machine learning

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.

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.