ВНИМАНИЕ! На форуме начался конкурс - астрофотография месяца - МАЙ!
0 Пользователей и 1 Гость просматривают эту тему.
#Conversion of GCVS catalog to DSO Planner format#Author: Ed Vazhorov, vazhorov.wordpress.com, vazhorov@mail.ru#Get the gcvs5.txt from http://www.sai.msu.su/gcvs/gcvs/gcvs5/#Install Pandas and Numpy first: "pip install pandas"import numpy as npimport pandas as pdcolnames = ["Constell","GCVS","coords","VarType","magMax","magMinI","magMinII","magCode","Epoch","YearNova","Period","MmD","SpType","Ref1","Ref2","PMa","PMd","uIdent","Ident","VarTypeII","GCVSII","last"]try: df=pd.read_fwf("gcvs5.txt", delimiter='|', names=colnames, header=None)except FileNotFoundError: df = pd.DataFrame(columns=cnames)else: df=pd.read_fwf("gcvs5.txt", delimiter='|', names=colnames, header=None)df=df[~df["Ref2"].str.contains("Not exists ")]df1=df[['GCVSII','coords','VarType','magMax','magMinI','Epoch','Period',"SpType"]]df1=df1[~df["coords"].str.contains(" ")]df2 = pd.DataFrame(columns=['name1','name2','ra','dec','vartype','mag','mag2','epoch','period','sptype','type','spacer'])df2['name1'] = df1.apply(lambda row: "&name1=" + str(row.GCVSII), axis=1).str.strip().str.replace(" ", " ").str.replace(" ", " ")df2['name2'] = df1.apply(lambda row: "name2=" + str(row.GCVSII), axis=1).str.strip().str.replace(" ", " ").str.replace(" ", " ")df2['ra'] = df1.apply(lambda row: int(row.coords[0:2]) + int(row.coords[2:4])/60 + float(row.coords[4:9].strip())/3600, axis=1)df2['ra'] = df2.apply(lambda row: "ra=" + str(round(row.ra, 6)), axis=1)df2['dec'] = df1.apply(lambda row: int(row.coords[10:13]) + int(row.coords[13:15])/60 + float(row.coords[15:19].strip())/3600, axis=1)df2['dec'] = df2.apply(lambda row: "dec=" + str(round(row.dec, 6)), axis=1)df2['vartype'] = df1.apply(lambda row: "vartype=" + str(row.VarType), axis=1).str.strip().str.replace(" ", "")df2['mag'] = df1.apply(lambda row: "mag=" + str(row.magMax), axis=1).str.strip().str.replace(" ", "")df2['mag2'] = df1.apply(lambda row: "mag2=" + str(row.magMinI), axis=1).str.strip().str.replace(" ", "")df2['epoch'] = df1.apply(lambda row: "epoch=" + str(row.Epoch).replace(". ", ".0").strip(), axis=1)df2['period'] = df1.apply(lambda row: "period=" + str(row.Period).replace(". ", ".0").strip(), axis=1).str.strip().str.replace(" ", "").str.replace("(", "").str.replace(")", "").str.replace(":", "")df2['sptype'] = df1.apply(lambda row: "sptype=" + str(row.SpType).strip(), axis=1).str.strip().str.replace(" ", "")df2['type'] = "type=star";df2['spacer'] = "";df2.to_csv("gcvs5.csv", encoding='utf-8', index=False, sep=';', header=False)
Могу сказать где это находится и как прописать.