Pandsa to Excel conversion issue

2021-06-01 Thread EK Esawi via Python-list
Hi All-- I am using Pandas to read an excel file which is very "dirty" and needs cleaning. I read the file via pandas and did not setup dtypes or converters hoping i can do so later.. When i run my code, most columns did come out as strings but i cannot convert them to float or integer using

cvxopt install problem

2015-11-03 Thread Ek Esawi
Hi All— I needed to install cvxopt on a 64 bit W7. I found out that cvxopt is incompatible with a 64 bit. It only compatible with a 32 bit which can be installed on a 64 bit computer and it works. I stumbled on this on another discussion group posting. The suggestion was to install python 32

Pandas' loading a CSV file problem

2015-10-22 Thread Ek Esawi
of massages such as Traceback (most recent call last): File "C:\Users\EK Esawi\Anaconda3\Scripts\file1.py", line 3, in f = pd.read_csv('c:/Users/EK Esawi/My Documents/Temp/GOSATemp.csv') File "C:\Users\EK Esawi\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 474

Pandas' loading a CSV file problem

2015-10-22 Thread Ek Esawi
Thanks you all for the input. Michiel's suggestion worked. At first It gave me an error about "low_memory"; once i sat low_memory to false, it worked. I am new to pandas and i am working on a 20,000 record csv file with mixed data types and in many cases, one entry (cell) has a combination of

Pandas' loading a CSV file problem

2015-10-22 Thread Ek Esawi
Here is the whole output. EKE Traceback (most recent call last): File "C:\Users\EK Esawi\Anaconda3\Scripts\MyFile.py", line 3, in f = pd.read_csv('c:/Users/EK Esawi/My Documents/Temp/GOSATemp1.csv') File "C:\Users\EK Esawi\Anaconda3\lib\site-packages\pandas\io\parser

PY3.5 and nnumpy and scipy installation problem

2015-09-29 Thread Ek Esawi
Hi All again— Thanks to all who have provided excellent tips for installing Python, Numpy, Scipy, etc. Paul suggested the use Anaconda which proved to be the best and easiest way for me. If I may add I stumbled on an academic site that spells out in great details how to install Python, numpy,

PY3.5 and nnumpy and scipy installation problem

2015-09-27 Thread Ek Esawi
Hi Steven, Thank you for the prompt response. What I meant by not working is the following: once I had py3.5 working, I downloaded numpy and scipy and unzipped them. After that I tried to install them. But there is no install file for either. There was a setup file which I thought would do the

PY3.5 and nnumpy and scipy installation problem

2015-09-26 Thread Ek Esawi
Hi All— I am a beginner in Python and new to this list, but I am an experienced programming in a few other languages. Last year I installed numpy and scipy for Python3.3 on my computer with windows 7, 64 bit OS. Today I downloaded Python3.5, but I the installation for numpy 1.9.2 or 1.9.3 nor