Python |
I learned to use Python in a project where a large number of big text files had to be converted to a Microsoft SQL Server environment. A colleague convinced me that Python was best fit for purpose. The language is very flexible and I especially like the generator concept. A generator is a function that yields one object at every call. An example is a function that delivers one record from a files each time it is called. This was used in combination with a dictionary that describes for each field in the record its characteristics and the transformation that was needed. In this way an array of fields was produced that then was read into an SQL Server table.
Python contains many standard functions but there is also a large community of Python users that make available code/packages. I was impressed by the possibilities of Python at converting data from one form to another.
For the many other areas of application of Python see ABOUT in the official website.