Apparently the KDE network icon is white when connected and has a splash of green on it when disconnected. Green? I’m not quite sure because I think I’ve seen a splash of red on it sometimes. I know…just google it. But why can’t it just be obvious? I usually have to waste time by hovering …
Monthly Archives: July 2020
Early Jupyter Notebook confusion
You can insert empty cells into a Jupyter Notebook by typing A for after or B for for before…I thought I read. Right? Wrong! It’s is A for above and B for below! The exact opposite. I’ve done that wrong more than a few times.
Juypter Notebooks in VS Code
Accidently opened a Juypter Notebook file with VS Code and it worked! I can run individual code cells just like in the browser! Similarly I opened a Python file that needs the Anaconda environment because that’s currently the only place I have pandas installed, and as long as the interpreter is correct…it works also!
Pandas loc and trying what you learned
Watched YouTube video that showed the loc method to locate a value in your data.df.loc[df[“column”]==”string”]) However when I tried it on a first name field that I knew was there…it didn’t find any. My data had trailing spaces and I found that if I added trailing spaces to the string (“string “) it found the …
Bye Bye Pycharm
It’s back to VS Code. Somehow a Python program I was working on with PyCharm in one of my Python subdirectory got saved to my home directory. That’s strange. That never happened in all the time I used VS Code. Oh well I’ll just move it back to where I keep almost all…if not all …
Pandas, large file…old computer
Sorting 1M records on old computer…around 3sec! CPU: AMD Phenom 8450 Triple- (3) @ 2.100GHzMemory: 2283MiB / 3935MiB %timeit %timeit df.sort_values([“Last”, “First”])2.97 s ± 8.8 ms per loop (mean ± std. dev. of 7 runs, 1 loop each)
Udemy Data Analysis with Pandas and Python course
Well predictably my progress in my Udemy Data Analysis with Pandas and Python course is slower than I’d like. Mostly as I previously said, the video doesn’t work properly. And I’m at this location ~11 hrs a day 5 days a week. It works fine on Linux Mint and Manjaro on my home computer, so …
Continue reading “Udemy Data Analysis with Pandas and Python course”
Pandas and a large file
I had to satisfy my curiosity and use Pandas on something substantial. So I did a read_csv on a million record file. Well IMHO…it’s fast. On my decent computer…not the fastest, by any stretch. The dataframe info, returned the following in the blink of an eye. Likewise a simple sum was instantaneous. I also did …