-1

While an analytics trial, the following dataframe was given command to save (this is happening inside loop, just showing the problem step).

Intended DataFrame

As you can see, this is just a normal dataframe with reasonably small number of rows (7171 rows) and columns (21 columns).

Upon saving this; the resultant file is >700 MB for some reason!

Upon opening the saved file (name and path of saving is correct, as intended), the following jumbled data was observed.

DataFrame upon saving as CSV

The whole file doesn't open, I think all the cells are filled >700 MB are filled with jumbled up values. Presently, I don't understand how this can happen and why this is happening.

Tried new session of R. Tried running the main loop step by step, still getting the weird results

Also, upon opening the csv output ans scrolling towards right, other zero column non-sense is observed:

enter image description here

Presently I have no clue how to solve this issue; witnessing this for the first time. Any help regarding solving this issue is highly appreciated.

thelatemail
  • 85,757
  • 12
  • 122
  • 177
N V
  • 81
  • 1
  • 12
  • It's easier to help you if you provide a [reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) with sample input and desired output that can be used to test and verify possible solutions. Please do not post data as images. How are you opening the CSV files? In Excel? It's not clear to me exactly what's "jumbled up". Are you just concerned that there are more decimal places in the output? R typically rounds values to a "reasonable" point when printing values to the console but writes out all values to CSV files. – MrFlick Jun 01 '22 at 21:46
  • Without seeing even the line of code you used, how are we suppose to provide advice on what went wrong? – Dave2e Jun 01 '22 at 22:08

0 Answers0