On: Ditching Excel for Python in a legacy industry

[x87678r]

I do a lot of both. Excel really is great for data where there are less than say 100k rows. Its just so easy to see exactly what you're doing and what the data looks like. If you have millions of records Python really does better but I still find it frustrating to find a way to keep peeking behind the curtain.

Ideally I'd have a type safe language which can embed data the way excel does. If Excel had dotnet languages instead of VBA and could store data arrays in XLBs it'd slay.

[nojito → x87678r]

Excel can easily handle tens of millions to hundreds of millions of rows of data.

Check out power query and power pivot.

[jbjbjbjb → x87678r]

Try ExcelDna it lets you hook up .net to Excel

[x87678r → jbjbjbjb]

Yes I use Excel DNA, it just doesn't have the same flexibility that I can email anyone a spreadsheet file containing both code and data.