0

I know how to import and manipulate data from csv, but I always need to save to xlsx or so to see the changes. Is there a way to see 'live changes' as if I am already using Excel?

PS using pandas

Thanks!

Brainiac
  • 75
  • 10
  • Yes, build your own output script that keeps refreshing from an in-memory structure. Something like this: https://github.com/kristianperkins/x_x Alternatively you could use something like jupyter notebook to view the data structure in real time – BoboDarph Oct 18 '18 at 09:59
  • @BoboDarph Thank. Could creating an excel macro or visual basic be more effective in that case as well? – Brainiac Oct 18 '18 at 10:28
  • 1
    Not to my knowledge. The data structure must be accessible to that script you plan to write. There are cheaper ways to visualise a pandas dataframe. Something like this could work: https://stackoverflow.com/questions/10636024/python-pandas-gui-for-viewing-a-dataframe-or-matrix – BoboDarph Oct 18 '18 at 10:40

1 Answers1

0

This is not possible using pandas. This lib creates copy of your .csv / .xls file and stores it in RAM. So all changes are applied to file stored in you memory not on disk.

Yaroslav
  • 83
  • 6
  • Thanks for your answer. Could an excel macro or visual basic do this task? – Brainiac Oct 18 '18 at 10:30
  • 1
    Seems that online showing changes in some dashboard or in jupyter notebook will be more common. So you may send new data to dash and for some cases build plots. See examples here: https://plot.ly/pandas/dashboard/ – Yaroslav Oct 18 '18 at 11:50