$ for p in $(pip list --format=columns | awk 'NR > 2 {print $1}'); do pip show $p | grep ^Location | grep -qs local && echo $p ; done
$ for p in $(pip list --format=columns | awk 'NR > 2 {print $1}'); do pip show $p | grep ^Location | grep -vqs local && echo $p ; done