[Tutor] Interoperating with Excel, was Re: Questions

2019-04-07 Thread Peter Otten
Diana Katz wrote: > 1) Can you use python from excel? Or just export to excel? > 2) I am trying to see if there's a way using python to automate all of > this work that I need to do. I have to collect quarterly segment data for > hundreds of public companies and go back at least 12-16 quarters. We

[Tutor] Questions

2019-04-07 Thread Diana Katz
1) Can you use python from excel? Or just export to excel? 2) I am trying to see if there's a way using python to automate all of this work that I need to do. I have to collect quarterly segment data for hundreds of public companies and go back at least 12-16 quarters. We use an aggregator like fac

[Tutor] Problem with Saved File

2019-04-07 Thread Stephen P. Molnar
I am using Spyder v-3.3.3 on Debian Stretch and have written a script to process data from another application. I am having a problem saving the resulting file [A] as a column vector. The vector is saved by np.savetxt(name_s,[A]). When I open the file in Spyder it is a column vector, but whe