[Scilab-users] csvRead hangs scilab for big csv file (more than 10000 lines)
Hi, I'm trying to load a big csv file ( 20002 lines). It seems that scilab fails when I have more than 1 lines in my csv file. If I try to csvRead the whole file, I have a spinning wait icon of death that stays there forever (I tried this night: it spinned for more than 17 hours). The only way to recover is to kill scilab (Ctrl+C does not work). If I split my file in several files with less than 1 lines, I can read each chunk in a matter of a few ms and concatenate them without a problem. As anyone ever experienced such a problem with csvRead? Antoine -- +++ Antoine Monmayrant LAAS - CNRS 7 avenue du Colonel Roche BP 54200 31031 TOULOUSE Cedex 4 FRANCE Tel:+33 5 61 33 64 59 email : antoine.monmayr...@laas.fr permanent email : antoine.monmayr...@polytechnique.org +++ ___ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] export to Excel with several sheets
Hi Thanks for the feedback, nevertheless I think it's not what I would like to do, I mean to create a xls file with several sheets to share it. Paul EXPORT CONTROL : Cet email ne contient pas de données techniques This email does not contain technical data De : users [mailto:users-boun...@lists.scilab.org] De la part de Clément DAVID Envoyé : lundi 1 octobre 2018 12:27 À : Users mailing list for Scilab Cc : Clément David Objet : [EXTERNAL] Re: [Scilab-users] export to Excel with several sheets Dear Paul, XLS_link [1] could be used to interact with Excel. This basically offer you the Excel OLE Automation API inside Scilab [2] and let you drive an Excel runtime using Scilab functions. Drawbacks : it requires an Excel licence and is Windows only. [1] : https://atoms.scilab.org/toolboxes/xls_link/ [2] https://support.microsoft.com/en-us/help/219151/how-to-automate-microsoft-excel-from-visual-basic Thanks, -- Clément From: users On Behalf Of Carrico, Paul Sent: Monday, October 1, 2018 11:20 AM To: International users mailing list for Scilab. (users@lists.scilab.org) Subject: [Scilab-users] export to Excel with several sheets Dear All I'm wondering if we can export matrixes from Scilab into Excel, in a single file but with several sheets? Obviously the csv format cannot be used here. Not sure that the (quite old now) XLL project answers to it (I've not seen any doc) Thanks Paul ___ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] csvRead hangs scilab for big csv file (more than 10000 lines)
Hi all, I submitted a bug report with a test script and csv file: http://bugzilla.scilab.org/show_bug.cgi?id=15788 Could you try it with your os/scilab-version and comment the bug report? Cheers, Antoine Le 02/10/2018 à 09:36, antoine.monmayr...@laas.fr a écrit : Hi, I'm trying to load a big csv file ( 20002 lines). It seems that scilab fails when I have more than 1 lines in my csv file. If I try to csvRead the whole file, I have a spinning wait icon of death that stays there forever (I tried this night: it spinned for more than 17 hours). The only way to recover is to kill scilab (Ctrl+C does not work). If I split my file in several files with less than 1 lines, I can read each chunk in a matter of a few ms and concatenate them without a problem. As anyone ever experienced such a problem with csvRead? Antoine -- +++ Antoine Monmayrant LAAS - CNRS 7 avenue du Colonel Roche BP 54200 31031 TOULOUSE Cedex 4 FRANCE Tel:+33 5 61 33 64 59 email : antoine.monmayr...@laas.fr permanent email : antoine.monmayr...@polytechnique.org +++ ___ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
[Scilab-users] array constructors
Hi, In scilab 6.1, I've noticed that the array [8.9:0.2:9.9] does contain 8.9 and 9.9, but the array, [-5.1:0.2:5.1] does not contain the last element 5.1! find([-5.1:0.2:5.1] == 5.1) = [] Why is that? Isn't it a bug? Thanks ___ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] array constructors
Le 02/10/2018 à 18:37, Adelson Oliveira a écrit : Hi, In scilab 6.1, I've noticed that the array [8.9:0.2:9.9] does contain 8.9 and 9.9, but the array, [-5.1:0.2:5.1] does not contain the last element 5.1! find([-5.1:0.2:5.1] == 5.1) = [] Why is that? Isn't it a bug? We have --> a = -5.1:0.2:5.1; --> delta = a($)+0.2-5.1 delta = 8.882D-16 --> delta/5.1/%eps ans = 0.7843137 So, computing the next value leads to 5.1 /but with an excess/ within the epsilon machine. Because of this excess, this last value is not included in the output set. I am wondering whether we could detect this kind of edge effects, and manage them more softly. Samuel ___ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] array constructors
On 02.10.2018, at 20:31, Samuel Gougeon wrote: > > Le 02/10/2018 à 18:37, Adelson Oliveira a écrit : >> Hi, >> >> In scilab 6.1, I've noticed that the array >> >> [8.9:0.2:9.9] does contain 8.9 and 9.9, >> >> but the array, >> >> [-5.1:0.2:5.1] >> >> does not contain the last element 5.1! >> >> find([-5.1:0.2:5.1] == 5.1) = [] >> >> Why is that? >> >> Isn't it a bug? > > We have > --> a = -5.1:0.2:5.1; > --> delta = a($)+0.2-5.1 > delta = >8.882D-16 > > --> delta/5.1/%eps > ans = >0.7843137 > > So, computing the next value leads to 5.1 but with an excess within the > epsilon machine. > Because of this excess, this last value is not included in the output set. > > I am wondering whether we could detect this kind of edge effects, and manage > them more softly. > > Samuel UNDERSTOOD. But what is a safe way to plot histograms like histplot(a:b:c, X) where X is a one-dimensional array? Heinz ___ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] array constructors
Le 02/10/2018 à 21:02, Heinz Nabielek a écrit :
On 02.10.2018, at 20:31, Samuel Gougeon wrote:
Le 02/10/2018 à 18:37, Adelson Oliveira a écrit :
Hi,
In scilab 6.1, I've noticed that the array
[8.9:0.2:9.9] does contain 8.9 and 9.9,
but the array,
[-5.1:0.2:5.1]
does not contain the last element 5.1!
find([-5.1:0.2:5.1] == 5.1) = []
Why is that?
Isn't it a bug?
We have
--> a = -5.1:0.2:5.1;
--> delta = a($)+0.2-5.1
delta =
8.882D-16
--> delta/5.1/%eps
ans =
0.7843137
So, computing the next value leads to 5.1 but with an excess within the epsilon
machine.
Because of this excess, this last value is not included in the output set.
I am wondering whether we could detect this kind of edge effects, and manage
them more softly.
Samuel
UNDERSTOOD. But what is a safe way to plot histograms like histplot(a:b:c, X)
where X is a one-dimensional array?
histplot(linspace(a, c, round((c-a)/b), X)
or
histplot(a:b:nearfloat("succ",c), X)
___
users mailing list
users@lists.scilab.org
http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] Punch a hole into a facet
Le 01/10/2018 à 16:35, Jens Simon Strom a écrit :
Thanks Samuel,
%nan works with surf, not with plot3d. The latter is attractive
because it can handle polygons - but unfortunately not those with
embayments: Facet coloring exeeds the contour (Vers. 5.5.2)
This is fixed in Scilab 6.
I have to assemble my facet with several windos from partially
overlapping rectangles
You may use this:
xf = [1 -1 -1 1 1 0.5 0.5 -0.5 -0.5 0.5]';
yf = [-1 -1 1 1 -1 -0.5 0.5 0.5 -0.5 -0.5]';
zf = zeros(yf);
red = color("red");
plot3d(xf, yf, list(zf, red))//Facet
set(gce(), "foreground", red, "hiddencolor", red);
___
users mailing list
users@lists.scilab.org
http://lists.scilab.org/mailman/listinfo/users
Re: [Scilab-users] array constructors
On 02.10.2018, at 21:12, Samuel Gougeon wrote:
>
> Le 02/10/2018 à 21:02, Heinz Nabielek a écrit :
>> On 02.10.2018, at 20:31, Samuel Gougeon wrote:
>>> Le 02/10/2018 à 18:37, Adelson Oliveira a écrit :
Hi,
In scilab 6.1, I've noticed that the array
[8.9:0.2:9.9] does contain 8.9 and 9.9,
but the array,
[-5.1:0.2:5.1]
does not contain the last element 5.1!
find([-5.1:0.2:5.1] == 5.1) = []
Why is that?
Isn't it a bug?
>>> We have
>>> --> a = -5.1:0.2:5.1;
>>> --> delta = a($)+0.2-5.1
>>> delta =
>>>8.882D-16
>>>
>>> --> delta/5.1/%eps
>>> ans =
>>>0.7843137
>>>
>>> So, computing the next value leads to 5.1 but with an excess within the
>>> epsilon machine.
>>> Because of this excess, this last value is not included in the output set.
>>>
>>> I am wondering whether we could detect this kind of edge effects, and
>>> manage them more softly.
>>>
>>> Samuel
>>
>> UNDERSTOOD. But what is a safe way to plot histograms like histplot(a:b:c,
>> X) where X is a one-dimensional array?
>
> histplot(linspace(a, c, round((c-a)/b), X)
> or
> histplot(a:b:nearfloat("succ",c), X)
THANKS THE LOT. I had all sort of problems in the past.
Heinz
___
users mailing list
users@lists.scilab.org
http://lists.scilab.org/mailman/listinfo/users
