Import data from Excel

2006-05-08 Thread N/A
Hi,
Is it possible to import data from Excel for doing numerical analysis in 
Python? If so how? Thank u!
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Import data from Excel

2006-05-08 Thread N/A
sorry, can you say it more clearly?
In Matlab, I can easily import data from Excel just simply use 'xlsread' 
command. How to do that in Python environment? thank u!

Paddy wrote:
> The CSV module?
> 
-- 
http://mail.python.org/mailman/listinfo/python-list


clear memory? how?

2006-05-09 Thread N/A
Hi all,
I am learning Python. Just wondering how to clear saved memory in 
Python? Like in Matlab I can simply use "clear all" to clear all saved 
memory.

Thank u!
-- 
http://mail.python.org/mailman/listinfo/python-list


Matplotlib in Python vs. Matlab, which one has much better graphical pressentation?

2006-05-09 Thread N/A
Hi all,

Can I have your opinions on Matlab vs. Matplotlib in Python in terms of 
2D and 3D graphical presentation please.

Matplotlib in Python vs. Matlab, which one has much better graphical 
pressentation?
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Econometrics in Panel data?

2006-05-10 Thread N/A
Oh! I think I should stop wasting time to learn Python to do my 
econometric algorithms. >_<


[EMAIL PROTECTED] wrote:
> Cameron Laird wrote:
>> In article <[EMAIL PROTECTED]>, I counseled:
>>> In article <[EMAIL PROTECTED]>,
>>> DeepBlue  <[EMAIL PROTECTED]> wrote:
 so are you saying that Python is not an appropriate language for doing
 econometrics stuff?


 Dennis Lee Bieber wrote:
> On Tue, 09 May 2006 05:58:10 +0800, DeepBlue <[EMAIL PROTECTED]> 
> declaimed the
> following in comp.lang.python:
>
>> Hi all,
>>
>> I am new to Python. Just wondering can Python able to do econometric
>> regression in either Time-series or pooled (panel) data? As well as test
>> for hetero, autocorrelation, or endogeneity?
>>  .
>>  .
>>  .
>>> There is not, however, a readily-accessible library targeted
>>> for this sort of work.  If I had the opportunity to work in
>>> econometrics now, I'd think seriously about R, Lisp, and
>>> Mathematica, and see what's available among the functional
>>> languages, along with Python.
>> Smalltalk, too; I'd throw it in the mix.  Much serious econometrics
>> has been done with Fortran, but I have no enthusiasm for pursuing
>> that direction, mostly because I think too much of the computing
>> world is going in a different one.
> 
> There are many statistics packages and programming languages used in
> econometrics and in general, so most of the computing world is going in
> a different
> "direction", no matter which package or language you choose.
> 
> Enough programmers still use Fortran that major hardware vendors such
> as Intel, IBM, and Sun are actively maintaining their Fortran 95
> compilers and adding features from Fortran 2003. G95 is free, available
> almost everywhere that gcc is, and good enough for production use IMO.
> 
> The recent book
> http://methcenter.psu.edu/newbooks/fortranbook/thebook.html
> Developing Statistical Software in Fortran 95
> by David R. Lemmon and Joseph L. Schafer
> Spriger (2005)
> 
> discusses how to build statistical software components in Fortran that
> can be used in statistical packages.
> 
> The IMSL and NAG software libraries have extensive statistical
> functionality and are available in Fortran, among other languages.
> 
> It is important for a programming language used for econometrics to
> conveniently handle multidimensional arrays, and here Fortran outshines
> C, C++, and Java (NumPy is good, though).
> 
> I am a quantitative financial analyst who implements econometrics
> algorithms. Data sets are getting bigger -- use of intraday data is now
> common -- and the CPU time for many algorithms scales as the N^2 or
> N^3, where N is the number of observations. Speed still matters.
> 
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: which windows python to use?

2006-05-11 Thread N/A
hi,

if mathematical and numerical algorithm are all you need, then just go 
for Enthought distribution + Matplotlib. The Enthought distribution 
provides all packages you need and handy for insatllation!

My combo:
1. Enthought Distribution
2. Matplotlib
3. EmEditor



Brian Blais wrote:
> Hello,
> 
> Are there any recommendations for which Windows python version to use?  
> I'd like to see a pros-and-cons description of each, given that 
> different uses might dictate different versions.  The versions I know 
> (and there are surely more) are:
> 
> 1) download from www.python.org
> 2) enthought
> 3) activepython
> 
> Are there advantages/disadvantages?  I have used enthought before, but 
> it seems as if they are not at 2.4, and may lag behind in versions 
> (which may not be a bad thing).
> 
> Any other recommendations?
> 
> 
> thanks,
> 
> Brian Blais
> 
> 
-- 
http://mail.python.org/mailman/listinfo/python-list


plot data from Excel sheet by Matplotlib, how?

2006-05-13 Thread N/A
Hi all,

Can any1 please guide me how to plot data from Excel by Matplotlib?
Let's say, I have 78(rows) x 8(cols) data in an Excel sheet. I would 
like to plot data for all 78(rows) at 4th column against data for all 
78(rows) at 7th column. How to plot it? Thank u!
-- 
http://mail.python.org/mailman/listinfo/python-list