Skip to content

Instantly share code, notes, and snippets.

@yaph

yaph/wikicsv.sh

Last active December 30, 2015 15:49
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yaph/7850515 to your computer and use it in GitHub Desktop.
Save yaph/7850515 to your computer and use it in GitHub Desktop.
Download ZIP
DBpedia/Wikipedia CSV manipulation
Raw
wikicsv.sh
# DBpedia table
csvcut -c 2 Film.csv | sed -e 's/(.*)$//' > film-titles.txt
# wikitables CSV
csvcut -c 1 List_of_Academy_Award-winning_films.csv | sed -e 's/(.*)//' | sed -e 's/\"//g' > film-titles.txt
# fix names
sed -e 's/|.*}//g' -e 's/{//' -i datasets/populated-places-locations.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment