Skip to content

Instantly share code, notes, and snippets.

@yaph
Last active December 30, 2015 15:49
Show Gist options
  • Save yaph/7850515 to your computer and use it in GitHub Desktop.
Save yaph/7850515 to your computer and use it in GitHub Desktop.
DBpedia/Wikipedia CSV manipulation
# 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