General Discussion on Python

Hi,

First of all thanks for adding me to the community.

I have a general question regarding IDEA and Python:
Does IDEA come with a Python 3.5.3 installation or is it necessary to have Python installed extra to be able to use it?

When I try to run a Python script from IDEA it says Windows does not know how to open the .py (Python) file. Reason is as far as I understand that Python is not installed and no compiler could be found.

For all IDEA users who are interested in Python programming I suggest to have a look on Pythonwin.
The application can be found in a subfolder of your IDEA installation f.e.:
C:\Program Files (x86)\CaseWare IDEA\IDEA\Lib\site-packages\pythonwin

So, should the need arise to get text prompts from python, I tested it and this works:
 

Since installing IDEA 10.3 I tried how to use the included Python modules. Finally my experience is that numpy, matplotlib, scikit and pandas work very well. However to transfer data from IDEA to Python/pandas our support recommends to export all data from IDEA to a Excel or Access file because the performance with RecordSet isn't optimal. From my point of view the performance with a dataset of <20k elements was ok. But if you wouldn't make use of RecordSet export to a CSV file seems the better solution because pandas.read_excel won't work due to the missing module xlrd.

Looking for a good source of functions used in EDA with Python (using Pandas library or any other). 
Basically my aim is to be able to derive quickly from a large set of data (usually over 20 000 records) the following information:
- what data is about
-main trends and patterns
Does anyone have any examples?

I just put together a package of python scripts for the IDEA Equation Editor. There are 18 functions that add on what you can do to a character string. You can find the package here:

http://ideascripting.com/IDEA_Lab/python-string-custom-functions