serhii.net

[Code]-Drop Rows with Non-Numeric Entries in a Column (Python)-pandas shows one way to do this using pd.to_numeric()¹:

df['Gm#'] = pd.to_numeric(df['Gm#'], errors='coerce')
df = df.dropna(subset=['Gm#'])

Sorting

Select the lines to sort, then :sort.

Diffing

When you’re looking at two files in two separate splits, :diffthis is the magic command.

Neat for manually diffing parts of jsons.

Previously: 230313-1423 json diff with jq

Move inside words separated by _

Wanted w/b in python not to skip over underscores, that is consider underscores word separators.

set iskeyword? shows the current/default value:

• in vim: iskeyword=@,48-57,,_,192-255
• in ideavim: iskeyword=@,48-57,_

Not digging to deep, removing _ gives me the wanted behaviour. Python got even easier now. (Keeping the ~/.vimrc as-is though).

EDIT: OK, but this breaks <C-*> and I can’t quickly jump between functions. Sad :( Rolling back…

Vim/Ideavim camelcase motion

• intellij idea - IdeaVim move between words in camel case word - Stack Overflow

IdeaVim supports camel case motions! Of course it does: ]w, [w, ]b, [b

I’m happy for my custom keyboard layout where brackets are REALLY close and usable. I love this.

But for pycharm, remapped them, giving me what I want:

 map w [w
 map e ]w
 map b [b 

When using black, this cryptic message

error: cannot format /experiment.py: cannot use --safe with this file; failed to parse source file.

happens to me only when I have a stray trailing comma in my imports:

from typing import Optional, Tuple,

• Sup/Subscripts: a_{multiplechars}
• Modulo: as-is |modulo|
• Parentheses: Brackets and Parentheses - Overleaf, Online-LaTeX-Editor List of LaTeX mathematical symbols - OeisWiki

Problem: jupyter notebooks being shown as text on my website.

Adding the following to a .htaccess file prevents files being “shown” in the browser, as opposed to downloaded¹:

<FilesMatch "\.(?i:doc|odf|pdf|rtf|txt|ipynb)$">
  Header set Content-Disposition attachment
</FilesMatch>

Also ² that there’s a HTML syntax for that in links now!

<a href="./my_file.txt" download>

ls has --color=always, but not everyone does.

sudo apt install expect-dev provides unbuffer¹, that when prefixed to a command makes it think it’s running in an interactive CLI, even if it’s piped or redirected etc.

For example this would preserve the colors in timew month’s output while changing text:

unbuffer timew month 2022-02-01 - 2022-04-01 | sed "s/what/ever/g"

Was trying to code a “is this a sortable thing or not” thing, saw the documentation for collections, and it’s awesome: collections.abc — Abstract Base Classes for Containers — Python 3.11.3 documentation

The table of base classes has who inherits from whom (Set from Collection), which abstract methods it has (__contains__) etc.

Definitely worth reading in full. As the rest of the very very readable Python docs.

> history

10640  echo command 1
10641  echo command 2
10642  echo command 3

Usually I’d !10640 !10642 to run 1 and 3, but there’s fc!¹

fc

fc -l to list instead of invoke.

fc first last, where the latter ones can be e.g:

• 12 for command 12
• -12 for command executed 12 commands ago

Then:

> fc -l 10639 
10639  h apt
10640  echo command 1
10641  echo command 2
10642  echo command 3
10643  history

> fc -l 10639 10642
10639  h apt
10640  echo command 1
10641  echo command 2
10642  echo command 3

> fc 10639 10642
% opens vim with these commands, edit then they get run on close.

Never thought about this till I saw this:

./file.sh
zsh: permission denied: ./file.sh

I’d usually chmod +x it, but sh file.sh works just as well!