Industry 4.0 solutions originally had their genesis in manufacturing. “The Fourth Industrial Revolution, Industry 4.0,… Read More
Improvement in production performance can enhance supply chain efficacy. There is a continuous discourse around… Read More
Sshhhhhh, ChatGPT knows everything!! In 2023, Generative AI (GenAI) emerged as a major technology disruption… Read More
Generative AI holds immense promise for healthcare, leveraging large datasets to innovate medical imaging, treatment… Read More
NJBIZ has recognized Naveen Gattu, Founder and Chief Operating Officer of Gramener—A Straive Company, as… Read More
This website uses cookies.
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