Python CasJobs.getNumpyArrayFromQuery示例

 def test_CasJobs_getNumpyArrayFromQuery(self):
     #CasJobs.getNumpyArrayFromQuery
     array = CasJobs.getNumpyArrayFromQuery(queryString=CasJobs_TestQuery,
                                            context=CasJobs_TestDatabase)
     newArray = pandas.read_csv(StringIO(CasJobs_TestTableCSV),
                                index_col=None).as_matrix()
     self.assertEqual(array.all(), newArray.all())

示例#2

显示文件

文件： Examples_SciScript-Python.py 项目： parthadeka/SciScript-Python

os.remove(CasJobs_TestFitsFile)


# In[ ]:

#get a Pandas dataframe containing the results of a query

df = CasJobs.getPandasDataFrameFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase)
print(df)


# In[ ]:

# get numpy array containing the results of a query

array = CasJobs.getNumpyArrayFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase)
print(array)


# In[ ]:

#uploads a Pandas dataframe into a Database table

df = pandas.read_csv(StringIO(CasJobs_TestTableCSV), index_col=None)
result = CasJobs.uploadPandasDataFrameToTable(dataFrame=df, tableName=CasJobs_TestTableName2, context="MyDB")
table = CasJobs.executeQuery(sql="select * from " + CasJobs_TestTableName2, context="MyDB", format="pandas")
print(result)
print(table)


# In[ ]: