Open your Excel Application and Plead for Forgiveness
Reading Time: < 1min
Gramener - A Straive Company
Gramener – A Straive company is a design-led data science firm. We build custom Data & Al solutions that help solve complex business problems with actionable insights and compelling data stories.
cool visuals. But I guess tableau is a better tool for that.
Here is what I think about excel:
1) Excel will mess-up with your dates. It may be confused if the dates are dd/mm/yy or mm/dd/yy
2) Excel does not play well with large spread-sheets.
3) Some basic stuff like removing duplicates can be pretty complicated in excel.
View Comments
cool visuals. But I guess tableau is a better tool for that.
Here is what I think about excel:
1) Excel will mess-up with your dates. It may be confused if the dates are dd/mm/yy or mm/dd/yy
2) Excel does not play well with large spread-sheets.
3) Some basic stuff like removing duplicates can be pretty complicated in excel.
https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
Compare this with a single method call .drop_duplicates in pandas.
http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.drop_duplicates.html
4) Excel does not integrate well with other applications like word or powerpoint. It is best used as stand alone tool.
5) Excel is relatively difficult to learn. At some point in future, I will need to invest time in learning VBA. Why not learn python instead?
This is fantastic! Well written to describe the unexplored territory of excel.
Excellent Richie... Loved it! Food for my thoughts