import from spreadsheet/csv

pfb shared this question 3 years ago
Answered

Hi,


I just created a dynamic worksheet to calculate the expected value of the work in a thermodynamic cycle.

I have access to a set of experimental data for the thermodynamic cycle, and I'd like to overlay them to the ideal theoretical curve (which my applet calculates).


I have done this for some colleagues who are not fluent in geogebra. I was thinking of adding a textbox with the name of the csv or xls file containing the data, and a button for loading it.

Is this possible in geogebra?


Thanks a lot

Comments (11)

photo
1

hello

open geogebra, open view spreadsheet, right cilck on a cell then import data file

is this enough for you?

saludos

photo
1

Hi mathmagic,


thanks for your reply. This would be definitely enough for me. It wouldn't be for my colleagues, though.


This is why I asked about the possibility of "adding a textbox with the name of the csv or xls file containing the data, and a button for loading it".


What I would like is a "look and feel" like in a standalone application.


Thanks again

Francesco

photo
1

Why don't you just pre-load the data into GeoGebra?


If you need several data-sets in a file then you can handle that with a slider or dropdown eg

https://www.geogebra.org/m/tbwXxySn

photo
1

Hi Michael,

thanks for your reply. In principle each experiment produces a different set of data.

They are more or less the same, so I might very well use one sample and that's it.

The idea is that everyone does their experiment and analyze their data. Maybe these files might have the same name.


I'd like to import the data file into geogebra and plot it, perhaps pushing a button?

photo
1

No ... I think that is not possible. You need to load them before BUT ... what Michael wants to say .... you can only show a part of the loaded data. It looks like you click on the button to load it, but the only think that happens is that you show the previously loaded data on demand.

photo
1

Hi Birgit,


Yes, I gathered that much from Michael's answer. However, as I say, what I was aiming at is a standalone application where everyone loads and analyzes "their own" data.

Since this is not currently possible, what Michael suggests could be a good compromise.

Toggle the sample dataset on/off.


Thanks a lot to you all!

I hope that command-line data import is in geogebra future features. For sure it is in my wishlist.

photo
1

I think that if a person has capacity for "everyone does their experiment and analyze their data" then he has capacity for "open geogebra, open view spreadsheet, right cilck on a cell then import data file"


photo
1

That would be nice. Unfortunately this is not my case.

The experiment is pretty self-contained. It is actually a very expensive toy connected to a couple of sensors.

The users basically lights a candle and pushes a button. More likely, the "technician" does that. He's a great guy, very handy, but not computer-savvy at all. Some of my colleagues are not much better.

So, these are the "boundary conditions" for my problem.

This is why self contained and user friendly applet would be preferable.


Anyway, what I was able to put together with the help of geogebra is pretty amazing, so I'm happy all the same.


Thanks again

F

photo
1

I don't see the "import data file" option anymore when I right-click on a free cell, where does it go?

All I see is "Paste"

photo
1

effectivement


s'il apparaît toujours en GGb5, il n'apparaît pas en GGb6

photo
1

Thanks. But why? It sounds like a very nice feature to me.

photo
© 2020 International GeoGebra Institute