René's URL Explorer Experiment

Title: CasJobs client returns string columns typed as 'object' instead of 'str' when format='pandas' · Issue #8 · sciserver/SciScript-Python · GitHub

Open Graph Title: CasJobs client returns string columns typed as 'object' instead of 'str' when format='pandas' · Issue #8 · sciserver/SciScript-Python

X Title: CasJobs client returns string columns typed as 'object' instead of 'str' when format='pandas' · Issue #8 · sciserver/SciScript-Python

Description: Try this in a notebook: df = CasJobs.executeQuery(sql="SELECT TOP 1 run2d FROM SpecObj", context='DR16', format="pandas") print(df['run2d'].dtype) The column type should be 'str' and not 'object'

Open Graph Description: Try this in a notebook: df = CasJobs.executeQuery(sql="SELECT TOP 1 run2d FROM SpecObj", context='DR16', format="pandas") print(df['run2d'].dtype) The column type should be 'str' and not 'object'

X Description: Try this in a notebook: df = CasJobs.executeQuery(sql="SELECT TOP 1 run2d FROM SpecObj", context='DR16', format="pandas") print(df['run2d'].dtype) The column typ...

Opengraph URL: https://github.com/sciserver/SciScript-Python/issues/8

X: @github

direct link

Domain: patch-diff.githubusercontent.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"CasJobs client returns string columns typed as 'object' instead of 'str' when format='pandas'","articleBody":"Try this in a notebook:\r\n\r\n```\r\ndf = CasJobs.executeQuery(sql=\"SELECT TOP 1 run2d FROM SpecObj\", context='DR16', format=\"pandas\")\r\nprint(df['run2d'].dtype)\r\n```\r\n\r\nThe column type should be 'str' and not 'object'","author":{"url":"https://github.com/dobos","@type":"Person","name":"dobos"},"datePublished":"2020-03-13T18:59:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/8/SciScript-Python/issues/8"}

Links:

Viewport: width=device-width