python dataframe write to R data format

Question

I have a question with writing a dataframe format to R.

I have 1000 column X 77 row data. I want to write this dataframe to R data.

When I use function of

r_dataframe = com.convert_to_r_dataframe(df)

it gives me an error like dataframe object has no arttribute type.

When I see the code of com.convert_to_r_dataframe(). it just get the column of dataframe, and get the colunm.dtype.type. In this moment, the column is dataframe, I think large columns dataframe has inside dataframes? Any one have some idea to solve this problem?

The feather-Package might help: blog.rstudio.org/2016/03/29/feather It is a format that both, Python and R can read — Rentrop
– Rentrop, Commented Mar 27, 2017 at 12:43
@Floo0 Thank you for your comment. but, I can not modify the R data server. I can only use python to save as R. — xiangjian Wu
– xiangjian Wu, Commented Mar 27, 2017 at 12:57
Feather does not currently support sparse dataframes either. — Ben Whale
– Ben Whale, Commented Mar 3, 2020 at 22:46

takje · Accepted Answer · 2017-03-27 13:28:16Z

11

The data.frame transfer from Python to R could be accomplished with the feather format. Via this link you can find more information.

Quick example.

Export in Python:

import feather
path = 'my_data.feather'
feather.write_dataframe(df, path)

Import in R:

library(feather)
path <- "my_data.feather"
df <- read_feather(path)

In this case you'll have the data in R as a data.frame. You can then decide to write it to an RData file.

save(df, file = 'my_data.RData')

answered Mar 27, 2017 at 13:28

takje

2,81031 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

xiangjian Wu Over a year ago

Thank you for your help. but I don't think this is the best way to impalement.

Jas Over a year ago

AttributeError: module 'feather' has no attribute 'write_dataframe'

Jas Over a year ago

pip install feather-format # resolved above AttributeError message

ℕʘʘḆḽḘ · Accepted Answer · 2017-03-27 12:54:14Z

4

simplest, bestest practical solution is to export in csv

import pandas as pd

dataframe.to_csv('mypath/file.csv')

and then read in R using read.csv

answered Mar 27, 2017 at 12:54

ℕʘʘḆḽḘ

19.5k39 gold badges148 silver badges259 bronze badges

4 Comments

xiangjian Wu Over a year ago

The python output must be Rdata. I just save dataframe to csv and read it using pd.read_csv(), but it also have the same problem.

ℕʘʘḆḽḘ Over a year ago

check this out stackoverflow.com/questions/15081858/…

Michael Tuchman Over a year ago

There are many good reasons why this is not the "simplest, bestest", but if you're going to make a superlative claim, be prepared to prove. it. to_csv can be quite slow, but more importantly, there is value not always having to divert to CSV, just to reimport it elsewhere from CSV. It can be helpful to have a more direct route to your destination.

dawid Over a year ago

Doesn't answer OP

Collectives™ on Stack Overflow

python dataframe write to R data format

2 Answers 2

3 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related