r/learnpython • • Apr 13 '22

What is difficult in excel but easy in Python?

If you were to introduce an established excel user [non VBA] to Python, what would you suggest?

What would amaze them? In as few a lines as possible?

404 Upvotes

241 comments sorted by

View all comments

Show parent comments

33

u/SSJKiDo Apr 13 '22

My coworker just set MS Excel as the default program for opening CSV files 😂

37

u/notalwayscapslock Apr 13 '22

As long they don't have to handle datasets with more than 1M rows I don't blame them

22

u/shutchomouf Apr 13 '22

Most people who work in Windows do.

0

u/[deleted] Apr 13 '22

[deleted]

6

u/SMAMtastic Apr 13 '22

Notepad++

3

u/tobiasvl tobiasvl Apr 14 '22

Well, Python is more powerful than Excel, but Excel is obviously more powerful than Notepad++... So that sounds weird to me.

4

u/Yevheniy Apr 13 '22

VS Code

Any notepad

Less / Cat

FILE *fp = fopen("filename.csv", "r+")

4

u/Pliqui Apr 14 '22

VSCode with `rainbow CSV` and `CSV/TSV/PSV to Table` extensions

|

1

u/leweyy Apr 14 '22

Get EmEditor. Pay for it. Best program.

1

u/sohang-3112 Jul 29 '22

Usually I use Excel, but sometimes I open CSVs in VS Code itself so that I don't have to open seperate programs for code and output. This works out well, since VS Code has several extensions for viewing / editing CSV files.

1

u/ActuallyNot Apr 14 '22

What else? Notepad?