Hi folks! Would you please explain how to get KWS data in JD-mag-error format without manual conversion of each date and time to JD? I can not find an explanation of ancient Japanise calendar using in the survey:
When I need to convert dates to JD, I usually import the file into Excel. If the column with dates is in date format, I can then create a new column with JD by adding 2415018.5 to the date values.
1 Like
Thank you, Thomas! I did not know that date format “2011-05-18 19:01:19” might be converted to decimal one just by cell re-formatting! I thought, it’s just ancient text 
The simplest operation, thank you!
I created a simply python code which requires Python astropy package for all the internal things. Code runs in Windows and Linux. Rename kws.txt to kws.py. It runs just:
python kws.py kws_input_file.txt and then shows the output table on screen or python kws.py kws_input_file.txt output_file.csv - then it saves output into output_file.csv for easy handling in Excel.
NB! The code expects KWS output format!
If you want really just JD mag error, then put comments in the python program text before output_table[‘Object’] = table[‘Object’] etc in the section with comment “Create output table with desired columns”.
kws.txt (2.7 KB)
Maybe it is useful… It definitely was useful for me… 
Best wishes,
Tõnis
1 Like