Jupyter Notebook vs. Microsoft Excel

I've created a number of daisy chain notebooks for different workflows, and every time, I create my workflows with other users in mind. Jupiter Notebook makes it very easy for me to outline my thought process in as granular a way as I want without using innumerable small. inline comments.

Incentivized

I don't really know another program as powerful as Excel. I've used Google Doc programs but do not feel they come close. So far, anytime I've needed a table of some sort for data, whether it's budget oriented or information off a survey, the best system has been Excel. We do web audits on occasion and we create an Excel worksheet featuring every URL of the pages we're auditing, notes, data about the content, information about files attached to the page and other information to help us determine what pages need updating, deleting or otherwise. We also use Excel primarily to export our Google Analytics to in order for us to create reports for clients that need to see specific information about their traffic.

Incentivized

• Simple and elegant code writing ability. Easier to understand the code that way.
• The ability to see the output after each step.
• The ability to use ton of library functions in Python.
• Easy-user friendly interface.

Incentivized

• It is very good at embedded formulas and tying cells to one another
• It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily.
• It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing.

Incentivized

• Need more Hotkeys for creating a beautiful notebook. Sometimes we need to download other plugins which messes [with] its default settings.
• Not as powerful as IDE, which sometimes makes [the] job difficult and allows duplicate code as it get confusing when the number of lines increases. Need a feature where [an] error comes if duplicate code is found or [if a] developer tries the same function name.

Incentivized

• Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
• Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
• Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.

Incentivized

Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.

Incentivized

Jupyter is highly simplistic. It took me about 5 mins to install and create my first "hello world" without having to look for help. The UI has minimalist options and is quite intuitive for anyone to become a pro in no time. The lightweight nature makes it even more likeable.

Incentivized

I'm giving it a 7 because it is my go to. But the fact other prefer Google Sheets when working with a team does get irritating. I've used the online version of Microsoft Excel that other teams can get into and it still seems behind Google Sheets. It's a little clanky and slow? If that's even a term.

Incentivized

I have rarely, if ever, had issues with its availability.

Incentivized

Excel load and performs calculations immediately. It integrate well with all Microsoft Office applications and does not slow them down.

Incentivized

I haven't had a need to contact support. However, all required help is out there in public forums.

Incentivized

I have not had to use it often, but it is good.

Incentivized

With Jupyter Notebook besides doing data analysis and performing complex visualizations you can also write machine learning algorithms with a long list of libraries that it supports. You can make better predictions, observations etc. with it which can help you achieve better business decisions and save cost to the company. It stacks up better as we know Python is more widely used than R in the industry and can be learnt easily. Unlike PyCharm jupyter notebooks can be used to make documentations and exported in a variety of formats.

Incentivized

Out of Microsoft Excel, Microsoft Power BI, IBM SPSS, and Google Sheets, Microsoft Excel is by far the most common tool used for anything data-related across organizations. Accordingly, our organization has also implemented Microsoft Excel as a first-step tool. We recently adopted Microsoft Power BI (the free version), and use it occasionally (mostly for creating dashboards), but it is less commonly understood by stakeholders across our organization and by our clients. Accordingly, Microsoft Excel is more user-friendly and because of its popularity, we can easily look up how to do things in the program online. Google Sheets is a comparable alternative to Microsoft Excel, but because it's cloud-based and we have sensitive data that needs to be protected, we chose against using this software. Finally, a few users (including myself) have access to and utilize IBM's SPSS. For my role, it's a helpful tool to do more rigorous analyses. However, because of its cost and limited functionality as a simple spreadsheet, we only use it for more complex analyses.

Incentivized

N/A I was not involved in this process.

Incentivized

Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise

Incentivized

• Positive impact: flexible implementation on any OS, for many common software languages
• Positive impact: straightforward duplication for adaptation of workflows for other projects
• Negative impact: sometimes encourages pigeonholing of data science work into notebooks versus extending code capability into software integration

Incentivized

• Excel has positively impacted the business as it has increased our efficiency.
• It also saves us the time that we would have spent on making the calculations that it does for us.
• Since it works on all devices and is compatible with both Windows and Mac, we do not have to invest in any other alternative.