apple/turicreate

sqlalchemy connection & pandas `object` dtype

Open

#92 opened on Dec 14, 2017

View on GitHub
 (5 comments) (0 reactions) (0 assignees)C++ (11,135 stars) (1,161 forks)batch import
SFramebugenginegood first issuep4

Description

It seems turicreate doesn't like sqlalchemy connections. Fair enough. I can connect to it using pandas instead and then create an SFrame from it.

Turns out, though, that in pandas string types are represented under the umbrella of dtype(O). And turicreate doesn't recognise these as strings.

pandas and sqlalchemy play really nice with each other, and I would wage there's a lot of people in the community who use these in conjunction to simplify fast prototyping. Is this problem something you would like to look into?

Contributor guide

Tech stack
pythonpandas
Domain
datamachine learning
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Familiarity with pandasBasic understanding of SFramePython programming
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60
Research direction
Investigate how turicreate's SFrame constructor maps pandas DataFrame dtypes. Look at the Python bindings for SFrame construction, likely in src/python/turicreate/data structures/sframe.py or similar. Identify if pandas object dtype is being coerced to a different type and modify the conversion logic to treat it as a string. Review the comments on issue #92 for any additional context or suggested approaches.
sqlalchemy connection & pandas `object` dtype · apple/turicreate#92 | Good First Issue