Blog

I am working first time database. I had never inserted data into database. I want to insert below csv into mysql database. Cell id too Issue Valid DPT RH TMP U V 1 1 22383 2015-01-15 00:00:00 GMT 2015-01-15 00:00:00 GMT 269.8000183 80.90000153 272.6300049 3.039999962 -0.560000002 101 1 22089 2015-01-15 00:00:00 GMT 2015-01-15 00:00:00 GMTRead more

I am doing some data scraping from websites, now my question is, what is the best strategy for data cleaning for fields to persist them in a database (e.g like MySQL?) I am working mainly with Python and SQLAlchemy, the data fields are often not in a unique prepared form and can have values likeRead more