Forum Discussion
How to convert more colums into a single one separated by ";"
To play with Python for Excel
import numpy
df = xl("dataArray", headers = False )
rows = numpy.matrix(df).tolist()
list(map(lambda x : '; '.join(x), rows) )Result is the same.
I have still to come to terms with this (I need to put some time aside). Does the access to Python libraries augment the world of spreadsheet formulas or replace it? For a hard-core Python programmer, I guess it is the latter, but do they need Excel and the worksheet environment.
I can see some places where rolling one's own formulas is verging on being too difficult (extracting eigenvalues for example) and a well-written library routine would inspire greater confidence. At the moment, though, I have so much more from the Excel formula language, particularly as it includes Lambda functions, than I might ever have dreamt of having to hand.
I think Python on Excel will have quite narrow niche. Libraries is definitely a plus. The rest - I'm not sure. Depends also on pricing model. Python for Power BI was introduced at least an year ago, but I don't see it becomes very popular in that environment.
But why don't to play with new tool.
- Yes, I really must play with it before it disappears and becomes irrelevant!