How to insert pandas dataframe into Cassandra table?

[Daniel Hong]

I am trying to insert a pandas dataframe into a Cassandra table, however I haven't been able to find anything examples online on how to do that except INSERT INTO VALUES statements...Does anyone know how this can be done?

[Adam Holmberg]

Can you provide your schema and sample application code for what you're trying?

On Thu, Oct 13, 2016 at 2:06 PM, Daniel Hong <daniel....@gmail.com> wrote:

I am trying to insert a pandas dataframe into a Cassandra table, however I haven't been able to find anything examples online on how to do that except INSERT INTO VALUES statements...Does anyone know how this can be done?

--
You received this message because you are subscribed to the Google Groups "DataStax Python Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to python-driver-user+unsub...@lists.datastax.com.

[Aaron Benz]

FYI - A while ago I was working on a package to make Cassandra and Pandas "easy" to use together (really for the Data Scientist). I called it "Caspanda"

I few people have helped keep it up to date, and we have some decent tutorials with it if you wanted to check it out. Reading from C* was pretty straight forward, and I did have some very basic examples working to write back to Cassandra, but alas, here it is: https://github.com/aaronbenz/caspanda

Honestly, one of my favorite parts about it was printing out the Cassandra tables in a way that reflected how data is actually stored as opposed to straight CQL table structures (particularly helpful for beginner NoSQL folks)

Best,
Aaron

To unsubscribe from this group and stop receiving emails from it, send an email to python-driver-user+unsubscribe@lists.datastax.com.

--
You received this message because you are subscribed to the Google Groups "DataStax Python Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to python-driver-user+unsub...@lists.datastax.com.

--

Aaron Benz

931-532-0452

aa...@zync-up.com

angel.co/zync-up

Schedule Time with Me Here

[Noelia]

Hi Aaron,

Thanks for creating caspanda!
However, the readme file does not explain how to save a dataframe to cassandra with caspanda.
If it is explained somewhere, would you be so kind as to point me to the explanation?
Otherwise, I would appreciate a simple example.

Thanks!!

On Tuesday, 18 October 2016 05:08:47 UTC+2, Aaron Benz wrote:

FYI - A while ago I was working on a package to make Cassandra and Pandas "easy" to use together (really for the Data Scientist). I called it "Caspanda"

I few people have helped keep it up to date, and we have some decent tutorials with it if you wanted to check it out. Reading from C* was pretty straight forward, and I did have some very basic examples working to write back to Cassandra, but alas, here it is: https://github.com/aaronbenz/caspanda

Honestly, one of my favorite parts about it was printing out the Cassandra tables in a way that reflected how data is actually stored as opposed to straight CQL table structures (particularly helpful for beginner NoSQL folks)

Best,
Aaron

On Mon, Oct 17, 2016 at 8:42 AM, Adam Holmberg <adam.h...@datastax.com> wrote:

Can you provide your schema and sample application code for what you're trying?

On Thu, Oct 13, 2016 at 2:06 PM, Daniel Hong <daniel....@gmail.com> wrote:

I am trying to insert a pandas dataframe into a Cassandra table, however I haven't been able to find anything examples online on how to do that except INSERT INTO VALUES statements...Does anyone know how this can be done?

--
You received this message because you are subscribed to the Google Groups "DataStax Python Driver for Apache Cassandra User Mailing List" group.

To unsubscribe from this group and stop receiving emails from it, send an email to python-driver-user+unsub...@lists.datastax.com.

--
You received this message because you are subscribed to the Google Groups "DataStax Python Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to python-driver-user+unsub...@lists.datastax.com.

[Emiliano Múgica]

Noelia & Daniel

Do you guys ever found a way to do this?