Pandas - Italian poets challenge

Download exercises

For a digital humanities project you need to display poets by filtering a csv table according to various criteria. This challenge will be only about querying with pandas, which is something you might find convenient to do during exams for quickly understanding datasets content (using pandas will always be optional, you will never be asked to perform complex modifications with it)

You are given a dataset taken from Wikidata, a project by the Wikimedia foundation which aims to store only machine-readable data, like numbers, strings, and so on interlinked with many references. Each entity in Wikidata has an identifier, for example Dante Alighieri is the entity Q1067 and Florence is Q2044

Wikidata can be queried using the SPARQL language: the data was obtained with this query and downloaded in CSV format (among the many which can be chosen). Even if not necessary for the purposes of the exercise, you are invited to play a bit with the interface, like trying different visualizations (i.e. try select map in the middle-left corner) - or see other examples

What to do

  1. If you haven’t already, install Pandas:

    Anaconda:

    conda install pandas

    Without Anaconda (--user installs in your home):

    python3 -m pip install --user pandas

  2. unzip exercises in a folder, you should get something like this:

pandas
    eures-jobs.ipynb
    eures-jobs-sol.ipynb
    italian-poets-chal.ipynb
    pandas.ipynb
    pandas-sol.ipynb
    jupman.py

WARNING 1: to correctly visualize the notebook, it MUST be in an unzipped folder !

  1. open Jupyter Notebook from that folder. Two things should open, first a console and then browser.

  2. The browser should show a file list: navigate the list and open the notebook pandas/italian-poets-chal.ipynb

WARNING 2: DO NOT use the Upload button in Jupyter, instead navigate in Jupyter browser to the unzipped folder !

  1. Go on reading that notebook, and follow instuctions inside.

Shortcut keys:

  • to execute Python code inside a Jupyter cell, press Control + Enter

  • to execute Python code inside a Jupyter cell AND select next cell, press Shift + Enter

  • to execute Python code inside a Jupyter cell AND a create a new cell aftwerwards, press Alt + Enter

  • If the notebooks look stuck, try to select Kernel -> Restart

Load the dataset

[1]:
import pandas as pd   # we import pandas and for ease we rename it to 'pd'
import numpy as np    # we import numpy and for ease we rename it to 'np'

df = pd.read_csv('italian-poets.csv', encoding='UTF-8')

Tell me more

Show some info about the dataset

Show solution
[2]:
# write here


<class 'pandas.core.frame.DataFrame'>
RangeIndex: 3198 entries, 0 to 3197
Data columns (total 6 columns):
subj          3198 non-null object
subjLabel     3198 non-null object
place         3198 non-null object
placeLabel    3198 non-null object
coord         3198 non-null object
birthyear     3070 non-null float64
dtypes: float64(1), object(5)
memory usage: 150.0+ KB

Getting in shape

Show the rows and the columns counts:

Show solution
[3]:
# write here


rows: 3198
columns: 3198

10 rows

Display first 10 rows

Show solution
[4]:
# write here


[4]:
subj subjLabel place placeLabel coord birthyear
0 http://www.wikidata.org/entity/Q8797 Aemilius Macer http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) NaN
1 http://www.wikidata.org/entity/Q8833 Gaius Maecenas http://www.wikidata.org/entity/Q13378 Arezzo Point(11.878055555 43.463055555) NaN
2 http://www.wikidata.org/entity/Q5592 Michelangelo http://www.wikidata.org/entity/Q52069 Caprese Michelangelo Point(11.985833333 43.640833333) 1475.0
3 http://www.wikidata.org/entity/Q6197 Horace http://www.wikidata.org/entity/Q52691 Venosa Point(15.816666666 40.966666666) -64.0
4 http://www.wikidata.org/entity/Q7170 Sallust http://www.wikidata.org/entity/Q177061 Amiternum Point(13.305769 42.400776) -85.0
5 http://www.wikidata.org/entity/Q7198 Ovid http://www.wikidata.org/entity/Q50157 Sulmona Point(13.926198 42.048025) -42.0
6 http://www.wikidata.org/entity/Q7728 Grazia Deledda http://www.wikidata.org/entity/Q13649 Nuoro Point(9.3280792 40.3200621) 1871.0
7 http://www.wikidata.org/entity/Q7803 Bronzino http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1503.0
8 http://www.wikidata.org/entity/Q8796 Sandra Lombardi http://www.wikidata.org/entity/Q220 Rome Point(12.482777777 41.893055555) 1946.0
9 http://www.wikidata.org/entity/Q8800 Gaius Maecenas Melissus http://www.wikidata.org/entity/Q20571 Spoleto Point(12.733333333 42.733333333) -100.0

Born in Verona

Display all people born in Verona

Show solution
[5]:
# write here


[5]:
subj subjLabel place placeLabel coord birthyear
0 http://www.wikidata.org/entity/Q8797 Aemilius Macer http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) NaN
135 http://www.wikidata.org/entity/Q163079 Catullus http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) -83.0
232 http://www.wikidata.org/entity/Q318593 Girolamo Fracastoro http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1478.0
256 http://www.wikidata.org/entity/Q539577 Guarino da Verona http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1374.0
375 http://www.wikidata.org/entity/Q1236766 Ippolito Pindemonte http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1753.0
436 http://www.wikidata.org/entity/Q620193 Aleardo Aleardi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1812.0
755 http://www.wikidata.org/entity/Q2293943 Cristina Ali Farah http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1973.0
764 http://www.wikidata.org/entity/Q1587432 Francesco Scipione, marchese di Maffei http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1675.0
858 http://www.wikidata.org/entity/Q3290043 Marco Antonio Zucchi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1750.0
891 http://www.wikidata.org/entity/Q3611735 Alida Airaghi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1953.0
1035 http://www.wikidata.org/entity/Q3638918 Berto Barbarani http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1872.0
1090 http://www.wikidata.org/entity/Q3663490 Caterina Bon Brenzoni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1813.0
1098 http://www.wikidata.org/entity/Q3665350 Cesare Betteloni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1808.0
1143 http://www.wikidata.org/entity/Q3741666 Federico Ceruti http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1532.0
1169 http://www.wikidata.org/entity/Q3746475 Flavio Ermini http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1947.0
1393 http://www.wikidata.org/entity/Q3762433 Giambattista Spolverini http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1695.0
1459 http://www.wikidata.org/entity/Q3766734 Giovanni Battista Pighi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1898.0
1489 http://www.wikidata.org/entity/Q3767945 Giovanni Pindemonte http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1751.0
1566 http://www.wikidata.org/entity/Q3768974 Girolamo Pompei http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1731.0
1694 http://www.wikidata.org/entity/Q4015300 Vittorio Betteloni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1840.0
1771 http://www.wikidata.org/entity/Q3081061 Francesco Pona http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1595.0
1869 http://www.wikidata.org/entity/Q3837018 Lorenzo Montano http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1893.0
1935 http://www.wikidata.org/entity/Q3846323 Marco Ongaro http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1956.0
2211 http://www.wikidata.org/entity/Q6999870 Rudy De Cadaval http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1933.0
2322 http://www.wikidata.org/entity/Q15432608 Ortensio Mauro http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1634.0
2361 http://www.wikidata.org/entity/Q15726796 Teresa Albarelli http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1788.0
2390 http://www.wikidata.org/entity/Q16574305 Luigi Nogarola http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1669.0
2460 http://www.wikidata.org/entity/Q17341090 Giovanni Ceriotto http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1883.0
2530 http://www.wikidata.org/entity/Q18945280 Francesco degli Allegri http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1495.0
2531 http://www.wikidata.org/entity/Q18945373 Giorgio Summaripa http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1435.0
2617 http://www.wikidata.org/entity/Q19597229 Giambattista Mutinelli http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1747.0
2634 http://www.wikidata.org/entity/Q20671732 Pietro Caliari http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1841.0
2651 http://www.wikidata.org/entity/Q23014868 Ilario Casarotti http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1772.0
2841 http://www.wikidata.org/entity/Q30126093 Girolamo Orti Manara http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1769.0
2850 http://www.wikidata.org/entity/Q30303339 Paolo Zazzaroni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) NaN
2872 http://www.wikidata.org/entity/Q28778065 Angela Nogarola http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1380.0
2885 http://www.wikidata.org/entity/Q30308589 Bartolomeo Tortoletti http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1560.0

How many people in Verona

Display how many people were born in Verona

Show solution
[6]:
# write here


[6]:
37

Python is everywhere

Show poets born in Catania in the year -500 (I swear I did not altered the dataset in any way :-)

Show solution
[7]:
# write here


[7]:
subj subjLabel place placeLabel coord birthyear
2231 http://www.wikidata.org/entity/Q7263938 Python of Catana http://www.wikidata.org/entity/Q1903 Catania Point(15.087269444 37.502669444) -500.0

Verona after 1500

Display all people born in Verona after the year 1500

Show solution
[8]:
# write here


[8]:
subj subjLabel place placeLabel coord birthyear
375 http://www.wikidata.org/entity/Q1236766 Ippolito Pindemonte http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1753.0
436 http://www.wikidata.org/entity/Q620193 Aleardo Aleardi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1812.0
755 http://www.wikidata.org/entity/Q2293943 Cristina Ali Farah http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1973.0
764 http://www.wikidata.org/entity/Q1587432 Francesco Scipione, marchese di Maffei http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1675.0
858 http://www.wikidata.org/entity/Q3290043 Marco Antonio Zucchi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1750.0
891 http://www.wikidata.org/entity/Q3611735 Alida Airaghi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1953.0
1035 http://www.wikidata.org/entity/Q3638918 Berto Barbarani http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1872.0
1090 http://www.wikidata.org/entity/Q3663490 Caterina Bon Brenzoni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1813.0
1098 http://www.wikidata.org/entity/Q3665350 Cesare Betteloni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1808.0
1143 http://www.wikidata.org/entity/Q3741666 Federico Ceruti http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1532.0
1169 http://www.wikidata.org/entity/Q3746475 Flavio Ermini http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1947.0
1393 http://www.wikidata.org/entity/Q3762433 Giambattista Spolverini http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1695.0
1459 http://www.wikidata.org/entity/Q3766734 Giovanni Battista Pighi http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1898.0
1489 http://www.wikidata.org/entity/Q3767945 Giovanni Pindemonte http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1751.0
1566 http://www.wikidata.org/entity/Q3768974 Girolamo Pompei http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1731.0
1694 http://www.wikidata.org/entity/Q4015300 Vittorio Betteloni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1840.0
1771 http://www.wikidata.org/entity/Q3081061 Francesco Pona http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1595.0
1869 http://www.wikidata.org/entity/Q3837018 Lorenzo Montano http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1893.0
1935 http://www.wikidata.org/entity/Q3846323 Marco Ongaro http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1956.0
2211 http://www.wikidata.org/entity/Q6999870 Rudy De Cadaval http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1933.0
2322 http://www.wikidata.org/entity/Q15432608 Ortensio Mauro http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1634.0
2361 http://www.wikidata.org/entity/Q15726796 Teresa Albarelli http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1788.0
2390 http://www.wikidata.org/entity/Q16574305 Luigi Nogarola http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1669.0
2460 http://www.wikidata.org/entity/Q17341090 Giovanni Ceriotto http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1883.0
2617 http://www.wikidata.org/entity/Q19597229 Giambattista Mutinelli http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1747.0
2634 http://www.wikidata.org/entity/Q20671732 Pietro Caliari http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1841.0
2651 http://www.wikidata.org/entity/Q23014868 Ilario Casarotti http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1772.0
2841 http://www.wikidata.org/entity/Q30126093 Girolamo Orti Manara http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1769.0
2885 http://www.wikidata.org/entity/Q30308589 Bartolomeo Tortoletti http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1560.0

First Antonio

Display all people with Antonio as first name

Show solution
[9]:
# write here


[9]:
subj subjLabel place placeLabel coord birthyear
47 http://www.wikidata.org/entity/Q266482 Antonio Bonfini http://www.wikidata.org/entity/Q3415 Ancona Point(13.516666666 43.616666666) 1427.0
48 http://www.wikidata.org/entity/Q266482 Antonio Bonfini http://www.wikidata.org/entity/Q3897778 Patrignone Point(13.60926 42.98027) 1427.0
77 http://www.wikidata.org/entity/Q348311 Antonio Tebaldeo http://www.wikidata.org/entity/Q13362 Ferrara Point(11.619865 44.835297) 1463.0
120 http://www.wikidata.org/entity/Q470067 Antonio Fogazzaro http://www.wikidata.org/entity/Q6537 Vicenza Point(11.55 45.55) 1842.0
203 http://www.wikidata.org/entity/Q524960 Antonio Ghislanzoni http://www.wikidata.org/entity/Q6237 Lecco Point(9.4 45.85) 1824.0
283 http://www.wikidata.org/entity/Q328132 Antonio Maria Lucchini http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) 1690.0
395 http://www.wikidata.org/entity/Q599437 Antonio Abati http://www.wikidata.org/entity/Q20458 Gubbio Point(12.5772674 43.3517882) 1600.0
396 http://www.wikidata.org/entity/Q599858 Antonio Beccadelli http://www.wikidata.org/entity/Q2656 Palermo Point(13.361262 38.115658) 1394.0
397 http://www.wikidata.org/entity/Q601697 Antonio Cornazzano http://www.wikidata.org/entity/Q13329 Piacenza Point(9.7 45.05) 1430.0
398 http://www.wikidata.org/entity/Q601778 Antonio Delfini http://www.wikidata.org/entity/Q279 Modena Point(10.92572 44.64582) 1907.0
399 http://www.wikidata.org/entity/Q602056 Antonio Francesco Grazzini http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1504.0
400 http://www.wikidata.org/entity/Q602183 Antonio Gazzoletti http://www.wikidata.org/entity/Q296262 Nago–Torbole Point(10.891111111 45.875833333) 1813.0
401 http://www.wikidata.org/entity/Q602343 Antonio Guadagnoli http://www.wikidata.org/entity/Q13378 Arezzo Point(11.878055555 43.463055555) 1798.0
402 http://www.wikidata.org/entity/Q602794 Antonio Lasciac http://www.wikidata.org/entity/Q6596 Gorizia Point(13.6193 45.9352) 1856.0
403 http://www.wikidata.org/entity/Q604378 Antonio Porchia http://www.wikidata.org/entity/Q53511 Conflenti Point(16.283333333 39.066666666) 1885.0
404 http://www.wikidata.org/entity/Q604378 Antonio Porchia http://www.wikidata.org/entity/Q53511 Conflenti Point(16.283333333 39.066666666) 1886.0
405 http://www.wikidata.org/entity/Q604396 Antonio Porta http://www.wikidata.org/entity/Q6537 Vicenza Point(11.55 45.55) 1935.0
406 http://www.wikidata.org/entity/Q604448 Antonio Pucci http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1310.0
408 http://www.wikidata.org/entity/Q604920 Antonio Salvi http://www.wikidata.org/entity/Q52084 Lucignano Point(11.746013888 43.274527777) 1664.0
409 http://www.wikidata.org/entity/Q604920 Antonio Salvi http://www.wikidata.org/entity/Q52084 Lucignano Point(11.746013888 43.274527777) 1664.0
410 http://www.wikidata.org/entity/Q605110 Antonio Minturno http://www.wikidata.org/entity/Q128105 Minturno Point(13.75 41.266666666) 1500.0
411 http://www.wikidata.org/entity/Q605623 Antonio Veneziano http://www.wikidata.org/entity/Q207448 Monreale Point(13.288888888 38.081666666) 1543.0
657 http://www.wikidata.org/entity/Q2087202 Antonio Schinella Conti http://www.wikidata.org/entity/Q617 Padua Point(11.877777777 45.406388888) 1677.0
759 http://www.wikidata.org/entity/Q2857170 Antonio Alamanni http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1464.0
760 http://www.wikidata.org/entity/Q2857327 Antonio Loschi http://www.wikidata.org/entity/Q6537 Vicenza Point(11.55 45.55) 1368.0
761 http://www.wikidata.org/entity/Q2857377 Antonio Neri http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1576.0
765 http://www.wikidata.org/entity/Q1607861 Antonio Bodrero http://www.wikidata.org/entity/Q20062 Frassino Point(7.283333333 44.566666666) 1921.0
943 http://www.wikidata.org/entity/Q3619133 Antonio Abbondanti http://www.wikidata.org/entity/Q50195 Imola Point(11.714722222 44.353055555) 1590.0
944 http://www.wikidata.org/entity/Q3619185 Antonio Aniante http://www.wikidata.org/entity/Q478954 Viagrande Point(15.1 37.616666666) 1900.0
945 http://www.wikidata.org/entity/Q3619193 Antonio Astesano http://www.wikidata.org/entity/Q17885 Villanova d'Asti Point(7.938333333 44.942777777) 1412.0
... ... ... ... ... ... ...
973 http://www.wikidata.org/entity/Q3620090 Antonio Ricciardi http://www.wikidata.org/entity/Q270782 Loano Point(8.259822222 44.129002777) 1700.0
974 http://www.wikidata.org/entity/Q3620097 Antonio Rinaldi http://www.wikidata.org/entity/Q3543 Potenza Point(15.8 40.633333333) 1914.0
975 http://www.wikidata.org/entity/Q3620099 Antonio Rinieri http://www.wikidata.org/entity/Q91192 Colle di Val d'Elsa Point(11.126666666 43.4225) 1535.0
976 http://www.wikidata.org/entity/Q3620129 Antonio Ruju http://www.wikidata.org/entity/Q13649 Nuoro Point(9.3280792 40.3200621) 1923.0
977 http://www.wikidata.org/entity/Q3620191 Antonio Scaglia http://www.wikidata.org/entity/Q241855 Storo Point(10.580277777 45.848888888) 1908.0
978 http://www.wikidata.org/entity/Q3620297 Antonio Veneziani http://www.wikidata.org/entity/Q13329 Piacenza Point(9.7 45.05) 1952.0
979 http://www.wikidata.org/entity/Q3620299 Antonio Verri http://www.wikidata.org/entity/Q52122 Caprarica di Lecce Point(18.25 40.266666666) 1949.0
980 http://www.wikidata.org/entity/Q3620389 Antonio della Porta http://www.wikidata.org/entity/Q51249 Montazzoli Point(14.433333333 41.95) 1868.0
2168 http://www.wikidata.org/entity/Q5699466 Antonio Querenghi http://www.wikidata.org/entity/Q617 Padua Point(11.877777777 45.406388888) 1546.0
2184 http://www.wikidata.org/entity/Q4776572 Antonio Denzio http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) 1689.0
2185 http://www.wikidata.org/entity/Q4776974 Antonio Seccareccia http://www.wikidata.org/entity/Q58622 Galluccio Point(13.95 41.35) 1920.0
2233 http://www.wikidata.org/entity/Q8201830 Antonio de Lofraso http://www.wikidata.org/entity/Q166282 Alghero Point(8.315 40.56) 1540.0
2259 http://www.wikidata.org/entity/Q11906048 Antonio Geraldini http://www.wikidata.org/entity/Q6238 Amelia Point(12.4167756 42.5535279) 1448.0
2321 http://www.wikidata.org/entity/Q15407381 Antonio Vignali http://www.wikidata.org/entity/Q2751 Siena Point(11.331388888 43.318333333) 1501.0
2404 http://www.wikidata.org/entity/Q17341050 Antonio Bianchi http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) NaN
2496 http://www.wikidata.org/entity/Q16527372 Antonio Baratella http://www.wikidata.org/entity/Q34373 Loreggia Point(11.95 45.6) 1385.0
2584 http://www.wikidata.org/entity/Q18812169 Antonio Nazzaro http://www.wikidata.org/entity/Q495 Turin Point(7.7 45.066666666) 1963.0
2596 http://www.wikidata.org/entity/Q19359527 Antonio De Santis http://www.wikidata.org/entity/Q277643 Larino Point(14.916666666 41.8) 1931.0
2623 http://www.wikidata.org/entity/Q22069363 Antonio Andrea Cucca http://www.wikidata.org/entity/Q13629 Sassari Point(8.559166666 40.726666666) 1870.0
2633 http://www.wikidata.org/entity/Q20639941 Antonio Cappelli http://www.wikidata.org/entity/Q279 Modena Point(10.92572 44.64582) 1818.0
2661 http://www.wikidata.org/entity/Q19918389 Antonio Telesio http://www.wikidata.org/entity/Q13619 Cosenza Point(16.25 39.3) 1482.0
2672 http://www.wikidata.org/entity/Q23833025 Antonio Giarola http://www.wikidata.org/entity/Q48027 Legnago Point(11.31148 45.19287) 1957.0
2703 http://www.wikidata.org/entity/Q21587591 Antonio Cubeddu http://www.wikidata.org/entity/Q391167 Ozieri Point(9.0032852 40.5848706) 1863.0
2763 http://www.wikidata.org/entity/Q24296444 Antonio Piazza http://www.wikidata.org/entity/Q6221 Brescia Point(10.220280555 45.538888888) 1795.0
2831 http://www.wikidata.org/entity/Q25094528 Antonio Torro http://www.wikidata.org/entity/Q52009 Castellaneta Point(16.933333333 40.633333333) 1891.0
2881 http://www.wikidata.org/entity/Q30250615 Antonio Bruni http://www.wikidata.org/entity/Q52019 Manduria Point(17.634166666 40.402777777) 1593.0
2917 http://www.wikidata.org/entity/Q42941837 Antonio Decio http://www.wikidata.org/entity/Q176180 Orte Point(12.386111111 42.460277777) 1560.0
2979 http://www.wikidata.org/entity/Q56166956 Antonio Rossetti http://www.wikidata.org/entity/Q51313 Vasto Point(14.708219444 42.111588888) 1770.0
3060 http://www.wikidata.org/entity/Q54860414 Antonio Ricci http://www.wikidata.org/entity/Q51240 Guardiagrele Point(14.221591666 42.189222222) 1952.0
3135 http://www.wikidata.org/entity/Q94075340 Antonio Gasparinetti http://www.wikidata.org/entity/Q46503 Ponte di Piave Point(12.466666666 45.716666666) 1777.0

85 rows × 6 columns

Some Antonio

Display all people with Antonio as one of the names (so also include 'Paolo Antonio Rolli')

Show solution
[10]:
# write here


[10]:
subj subjLabel place placeLabel coord birthyear
47 http://www.wikidata.org/entity/Q266482 Antonio Bonfini http://www.wikidata.org/entity/Q3415 Ancona Point(13.516666666 43.616666666) 1427.0
48 http://www.wikidata.org/entity/Q266482 Antonio Bonfini http://www.wikidata.org/entity/Q3897778 Patrignone Point(13.60926 42.98027) 1427.0
53 http://www.wikidata.org/entity/Q55433 Michelangelo Antonioni http://www.wikidata.org/entity/Q13362 Ferrara Point(11.619865 44.835297) 1912.0
77 http://www.wikidata.org/entity/Q348311 Antonio Tebaldeo http://www.wikidata.org/entity/Q13362 Ferrara Point(11.619865 44.835297) 1463.0
120 http://www.wikidata.org/entity/Q470067 Antonio Fogazzaro http://www.wikidata.org/entity/Q6537 Vicenza Point(11.55 45.55) 1842.0
203 http://www.wikidata.org/entity/Q524960 Antonio Ghislanzoni http://www.wikidata.org/entity/Q6237 Lecco Point(9.4 45.85) 1824.0
283 http://www.wikidata.org/entity/Q328132 Antonio Maria Lucchini http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) 1690.0
335 http://www.wikidata.org/entity/Q587778 Marco Antonio Canini http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) 1822.0
352 http://www.wikidata.org/entity/Q726893 Paolo Antonio Rolli http://www.wikidata.org/entity/Q220 Rome Point(12.482777777 41.893055555) 1687.0
395 http://www.wikidata.org/entity/Q599437 Antonio Abati http://www.wikidata.org/entity/Q20458 Gubbio Point(12.5772674 43.3517882) 1600.0
396 http://www.wikidata.org/entity/Q599858 Antonio Beccadelli http://www.wikidata.org/entity/Q2656 Palermo Point(13.361262 38.115658) 1394.0
397 http://www.wikidata.org/entity/Q601697 Antonio Cornazzano http://www.wikidata.org/entity/Q13329 Piacenza Point(9.7 45.05) 1430.0
398 http://www.wikidata.org/entity/Q601778 Antonio Delfini http://www.wikidata.org/entity/Q279 Modena Point(10.92572 44.64582) 1907.0
399 http://www.wikidata.org/entity/Q602056 Antonio Francesco Grazzini http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1504.0
400 http://www.wikidata.org/entity/Q602183 Antonio Gazzoletti http://www.wikidata.org/entity/Q296262 Nago–Torbole Point(10.891111111 45.875833333) 1813.0
401 http://www.wikidata.org/entity/Q602343 Antonio Guadagnoli http://www.wikidata.org/entity/Q13378 Arezzo Point(11.878055555 43.463055555) 1798.0
402 http://www.wikidata.org/entity/Q602794 Antonio Lasciac http://www.wikidata.org/entity/Q6596 Gorizia Point(13.6193 45.9352) 1856.0
403 http://www.wikidata.org/entity/Q604378 Antonio Porchia http://www.wikidata.org/entity/Q53511 Conflenti Point(16.283333333 39.066666666) 1885.0
404 http://www.wikidata.org/entity/Q604378 Antonio Porchia http://www.wikidata.org/entity/Q53511 Conflenti Point(16.283333333 39.066666666) 1886.0
405 http://www.wikidata.org/entity/Q604396 Antonio Porta http://www.wikidata.org/entity/Q6537 Vicenza Point(11.55 45.55) 1935.0
406 http://www.wikidata.org/entity/Q604448 Antonio Pucci http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1310.0
408 http://www.wikidata.org/entity/Q604920 Antonio Salvi http://www.wikidata.org/entity/Q52084 Lucignano Point(11.746013888 43.274527777) 1664.0
409 http://www.wikidata.org/entity/Q604920 Antonio Salvi http://www.wikidata.org/entity/Q52084 Lucignano Point(11.746013888 43.274527777) 1664.0
410 http://www.wikidata.org/entity/Q605110 Antonio Minturno http://www.wikidata.org/entity/Q128105 Minturno Point(13.75 41.266666666) 1500.0
411 http://www.wikidata.org/entity/Q605623 Antonio Veneziano http://www.wikidata.org/entity/Q207448 Monreale Point(13.288888888 38.081666666) 1543.0
440 http://www.wikidata.org/entity/Q741900 Giuseppe Marc'Antonio Baretti http://www.wikidata.org/entity/Q495 Turin Point(7.7 45.066666666) 1719.0
657 http://www.wikidata.org/entity/Q2087202 Antonio Schinella Conti http://www.wikidata.org/entity/Q617 Padua Point(11.877777777 45.406388888) 1677.0
667 http://www.wikidata.org/entity/Q1440903 Francesco Antonio Tullio http://www.wikidata.org/entity/Q2634 Naples Point(14.25 40.833333333) 1660.0
698 http://www.wikidata.org/entity/Q1528124 Giuseppe Antonio Borgese http://www.wikidata.org/entity/Q502657 Polizzi Generosa Point(13.999166666 37.811944444) 1882.0
759 http://www.wikidata.org/entity/Q2857170 Antonio Alamanni http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) 1464.0
... ... ... ... ... ... ...
2168 http://www.wikidata.org/entity/Q5699466 Antonio Querenghi http://www.wikidata.org/entity/Q617 Padua Point(11.877777777 45.406388888) 1546.0
2184 http://www.wikidata.org/entity/Q4776572 Antonio Denzio http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) 1689.0
2185 http://www.wikidata.org/entity/Q4776974 Antonio Seccareccia http://www.wikidata.org/entity/Q58622 Galluccio Point(13.95 41.35) 1920.0
2195 http://www.wikidata.org/entity/Q5479182 Francesco Antonio Santori http://www.wikidata.org/entity/Q13619 Cosenza Point(16.25 39.3) 1819.0
2196 http://www.wikidata.org/entity/Q5479182 Francesco Antonio Santori http://www.wikidata.org/entity/Q53987 Santa Caterina Albanese Point(16.066666666 39.583333333) 1819.0
2233 http://www.wikidata.org/entity/Q8201830 Antonio de Lofraso http://www.wikidata.org/entity/Q166282 Alghero Point(8.315 40.56) 1540.0
2259 http://www.wikidata.org/entity/Q11906048 Antonio Geraldini http://www.wikidata.org/entity/Q6238 Amelia Point(12.4167756 42.5535279) 1448.0
2321 http://www.wikidata.org/entity/Q15407381 Antonio Vignali http://www.wikidata.org/entity/Q2751 Siena Point(11.331388888 43.318333333) 1501.0
2404 http://www.wikidata.org/entity/Q17341050 Antonio Bianchi http://www.wikidata.org/entity/Q641 Venice Point(12.331944444 45.439722222) NaN
2496 http://www.wikidata.org/entity/Q16527372 Antonio Baratella http://www.wikidata.org/entity/Q34373 Loreggia Point(11.95 45.6) 1385.0
2584 http://www.wikidata.org/entity/Q18812169 Antonio Nazzaro http://www.wikidata.org/entity/Q495 Turin Point(7.7 45.066666666) 1963.0
2596 http://www.wikidata.org/entity/Q19359527 Antonio De Santis http://www.wikidata.org/entity/Q277643 Larino Point(14.916666666 41.8) 1931.0
2623 http://www.wikidata.org/entity/Q22069363 Antonio Andrea Cucca http://www.wikidata.org/entity/Q13629 Sassari Point(8.559166666 40.726666666) 1870.0
2633 http://www.wikidata.org/entity/Q20639941 Antonio Cappelli http://www.wikidata.org/entity/Q279 Modena Point(10.92572 44.64582) 1818.0
2649 http://www.wikidata.org/entity/Q23011800 Paolo Antonio del Negro http://www.wikidata.org/entity/Q1449 Genoa Point(8.933983333 44.407186111) 1664.0
2661 http://www.wikidata.org/entity/Q19918389 Antonio Telesio http://www.wikidata.org/entity/Q13619 Cosenza Point(16.25 39.3) 1482.0
2672 http://www.wikidata.org/entity/Q23833025 Antonio Giarola http://www.wikidata.org/entity/Q48027 Legnago Point(11.31148 45.19287) 1957.0
2676 http://www.wikidata.org/entity/Q23913628 Giuseppe Antonio Patrignani http://www.wikidata.org/entity/Q124572 Ostra, Marche Point(13.158230555 43.61265) 1659.0
2698 http://www.wikidata.org/entity/Q25813891 Niccolò Antonio Blasco http://www.wikidata.org/entity/Q53730 Taverna, Calabria Point(16.583333333 39.016666666) NaN
2703 http://www.wikidata.org/entity/Q21587591 Antonio Cubeddu http://www.wikidata.org/entity/Q391167 Ozieri Point(9.0032852 40.5848706) 1863.0
2763 http://www.wikidata.org/entity/Q24296444 Antonio Piazza http://www.wikidata.org/entity/Q6221 Brescia Point(10.220280555 45.538888888) 1795.0
2804 http://www.wikidata.org/entity/Q31752320 Pietro Antonio Bernardoni http://www.wikidata.org/entity/Q100111 Vignola Point(11.002222222 44.480833333) 1672.0
2831 http://www.wikidata.org/entity/Q25094528 Antonio Torro http://www.wikidata.org/entity/Q52009 Castellaneta Point(16.933333333 40.633333333) 1891.0
2846 http://www.wikidata.org/entity/Q39157044 Ferdinando Antonio Campeggi http://www.wikidata.org/entity/Q1891 Bologna Point(11.342777777 44.493888888) NaN
2881 http://www.wikidata.org/entity/Q30250615 Antonio Bruni http://www.wikidata.org/entity/Q52019 Manduria Point(17.634166666 40.402777777) 1593.0
2906 http://www.wikidata.org/entity/Q41566775 Carlo Antonio Bertelli http://www.wikidata.org/entity/Q111705 Salò Point(10.533333333 45.6) 1637.0
2917 http://www.wikidata.org/entity/Q42941837 Antonio Decio http://www.wikidata.org/entity/Q176180 Orte Point(12.386111111 42.460277777) 1560.0
2979 http://www.wikidata.org/entity/Q56166956 Antonio Rossetti http://www.wikidata.org/entity/Q51313 Vasto Point(14.708219444 42.111588888) 1770.0
3060 http://www.wikidata.org/entity/Q54860414 Antonio Ricci http://www.wikidata.org/entity/Q51240 Guardiagrele Point(14.221591666 42.189222222) 1952.0
3135 http://www.wikidata.org/entity/Q94075340 Antonio Gasparinetti http://www.wikidata.org/entity/Q46503 Ponte di Piave Point(12.466666666 45.716666666) 1777.0

110 rows × 6 columns

Cesares during 1800

Display all people named Cesare who were born in 1800 century

Show solution
[11]:
# write here


[11]:
subj subjLabel place placeLabel coord birthyear
389 http://www.wikidata.org/entity/Q1056872 Cesare Meano http://www.wikidata.org/entity/Q495 Turin Point(7.7 45.066666666) 1899.0
1098 http://www.wikidata.org/entity/Q3665350 Cesare Betteloni http://www.wikidata.org/entity/Q2028 Verona Point(10.992777777 45.438611111) 1808.0
1101 http://www.wikidata.org/entity/Q3665409 Cesare De Titta http://www.wikidata.org/entity/Q51292 Sant'Eusanio del Sangro Point(14.333333333 42.166666666) 1862.0
1105 http://www.wikidata.org/entity/Q3665495 Cesare Pascarella http://www.wikidata.org/entity/Q220 Rome Point(12.482777777 41.893055555) 1858.0

Sorting

Show poets in year of birth order

Show solution
[12]:
# write here


[12]:
subj subjLabel place placeLabel coord birthyear
292 http://www.wikidata.org/entity/Q332797 Stesichorus http://www.wikidata.org/entity/Q54614 Gioia Tauro Point(15.9 38.433333333) -629.0
293 http://www.wikidata.org/entity/Q332802 Ibycus http://www.wikidata.org/entity/Q8471 Reggio Calabria Point(15.65 38.114438888) -600.0
327 http://www.wikidata.org/entity/Q336115 Theognis of Megara http://www.wikidata.org/entity/Q1457477 Megara Hyblaea Point(15.18194444 37.20388889) -569.0
84 http://www.wikidata.org/entity/Q125551 Parmenides http://www.wikidata.org/entity/Q272968 Velia Point(15.154444444 40.159444444) -514.0
2575 http://www.wikidata.org/entity/Q20002641 Glaucus of Rhegion http://www.wikidata.org/entity/Q8471 Reggio Calabria Point(15.65 38.114438888) -500.0
2231 http://www.wikidata.org/entity/Q7263938 Python of Catana http://www.wikidata.org/entity/Q1903 Catania Point(15.087269444 37.502669444) -500.0
1293 http://www.wikidata.org/entity/Q3704810 Deinoloco http://www.wikidata.org/entity/Q13670 Syracuse Point(15.2875 37.069166666) -499.0
149 http://www.wikidata.org/entity/Q83375 Empedocles http://www.wikidata.org/entity/Q13678 Agrigento Point(13.576547222 37.311075) -489.0
196 http://www.wikidata.org/entity/Q512691 Sophron http://www.wikidata.org/entity/Q13670 Syracuse Point(15.2875 37.069166666) -469.0
788 http://www.wikidata.org/entity/Q2364741 Telestes of Selinus http://www.wikidata.org/entity/Q952173 Selinunte Point(12.824722 37.583611) -450.0
2232 http://www.wikidata.org/entity/Q7263938 Python of Catana http://www.wikidata.org/entity/Q1903 Catania Point(15.087269444 37.502669444) -400.0
771 http://www.wikidata.org/entity/Q2303706 Sosiphanes http://www.wikidata.org/entity/Q4420718 ancient Syracuse Point(15.28333333 37.08333333) -400.0
772 http://www.wikidata.org/entity/Q2303706 Sosiphanes http://www.wikidata.org/entity/Q4420718 ancient Syracuse Point(15.283333333 37.083333333) -400.0
794 http://www.wikidata.org/entity/Q2938009 Carcinus http://www.wikidata.org/entity/Q13678 Agrigento Point(13.576547222 37.311075) -379.0
2173 http://www.wikidata.org/entity/Q4966577 Alexis http://www.wikidata.org/entity/Q602564 Thurii Point(16.47111111 39.695) -371.0
274 http://www.wikidata.org/entity/Q547681 Philemon http://www.wikidata.org/entity/Q13670 Syracuse Point(15.2875 37.069166666) -361.0
774 http://www.wikidata.org/entity/Q2303706 Sosiphanes http://www.wikidata.org/entity/Q4420718 ancient Syracuse Point(15.283333333 37.083333333) -356.0
773 http://www.wikidata.org/entity/Q2303706 Sosiphanes http://www.wikidata.org/entity/Q4420718 ancient Syracuse Point(15.28333333 37.08333333) -356.0
222 http://www.wikidata.org/entity/Q210507 Archestratus http://www.wikidata.org/entity/Q39971 Gela Point(14.25 37.066666666) -350.0
414 http://www.wikidata.org/entity/Q927009 Leonidas of Tarentum http://www.wikidata.org/entity/Q13498 Taranto Point(17.240833333 40.418055555) -319.0
1834 http://www.wikidata.org/entity/Q3526540 Theodoridas of Syracuse http://www.wikidata.org/entity/Q13670 Syracuse Point(15.2875 37.069166666) -300.0
167 http://www.wikidata.org/entity/Q193058 Livius Andronicus http://www.wikidata.org/entity/Q13498 Taranto Point(17.240833333 40.418055555) -279.0
225 http://www.wikidata.org/entity/Q212667 Gnaeus Naevius http://www.wikidata.org/entity/Q3136685 Capua Point(14.25 41.083333333) -274.0
31 http://www.wikidata.org/entity/Q47160 Plautus http://www.wikidata.org/entity/Q99956 Sarsina Point(12.15 43.916666666) -249.0
29 http://www.wikidata.org/entity/Q47130 Ennius http://www.wikidata.org/entity/Q3942250 Rudiae Point(18.14729167 40.33379167) -238.0
160 http://www.wikidata.org/entity/Q180081 Cato the Elder http://www.wikidata.org/entity/Q754314 Tusculum Point(12.710833333 41.798333333) -233.0
80 http://www.wikidata.org/entity/Q350781 Caecilius Statius http://www.wikidata.org/entity/Q490 Milan Point(9.19 45.466944444) -229.0
190 http://www.wikidata.org/entity/Q314677 Pacuvius http://www.wikidata.org/entity/Q13496 Brindisi Point(17.945833333 40.638333333) -219.0
460 http://www.wikidata.org/entity/Q957548 Moschus http://www.wikidata.org/entity/Q13670 Syracuse Point(15.2875 37.069166666) -200.0
141 http://www.wikidata.org/entity/Q298729 Gaius Lucilius http://www.wikidata.org/entity/Q58898 Sessa Aurunca Point(13.933333333 41.233333333) -179.0
... ... ... ... ... ... ...
2858 http://www.wikidata.org/entity/Q47193241 Cristoforo Castelletti http://www.wikidata.org/entity/Q220 Rome Point(12.482777777 41.893055555) NaN
2859 http://www.wikidata.org/entity/Q50399164 Dolcibene de' Tori http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) NaN
2860 http://www.wikidata.org/entity/Q47697278 Melchiorre Mereu http://www.wikidata.org/entity/Q295248 Macomer Point(8.7750614 40.2643571) NaN
2861 http://www.wikidata.org/entity/Q65007348 Donata Berra http://www.wikidata.org/entity/Q490 Milan Point(9.19 45.466944444) NaN
2862 http://www.wikidata.org/entity/Q58195380 Roberto Ascoli http://www.wikidata.org/entity/Q3415 Ancona Point(13.516666666 43.616666666) NaN
2990 http://www.wikidata.org/entity/Q59365138 Ortensia di Guglielmo http://www.wikidata.org/entity/Q13145 Fabriano Point(12.908519444 43.338561111) NaN
2991 http://www.wikidata.org/entity/Q51845316 Q51845316 http://www.wikidata.org/entity/Q1449 Genoa Point(8.933983333 44.407186111) NaN
2992 http://www.wikidata.org/entity/Q52084523 Guido Ghislieri http://www.wikidata.org/entity/Q1891 Bologna Point(11.342777777 44.493888888) NaN
2993 http://www.wikidata.org/entity/Q66969505 Giovanni da Falgano http://www.wikidata.org/entity/Q82817 Rufina Point(11.483333333 43.816666666) NaN
2994 http://www.wikidata.org/entity/Q63321136 Marino Ceccoli http://www.wikidata.org/entity/Q3437 Perugia Point(12.3888 43.1121) NaN
2995 http://www.wikidata.org/entity/Q63383281 Giovanni Armonio http://www.wikidata.org/entity/Q50159 Tagliacozzo Point(13.254722222 42.069444444) NaN
2996 http://www.wikidata.org/entity/Q60838260 Q60838260 http://www.wikidata.org/entity/Q1273 Tuscany Point(11.016666666 43.35) NaN
2997 http://www.wikidata.org/entity/Q64433131 Q64433131 http://www.wikidata.org/entity/Q43034 Castel Goffredo Point(10.475 45.297777777) NaN
2998 http://www.wikidata.org/entity/Q64576509 Neri Moscoli http://www.wikidata.org/entity/Q20413 Città di Castello Point(12.2403118 43.4574214) NaN
2999 http://www.wikidata.org/entity/Q71684946 Q71684946 http://www.wikidata.org/entity/Q43090 Trezzo sull'Adda Point(9.516666666 45.6) NaN
3000 http://www.wikidata.org/entity/Q88178916 Domìzio Brocardo http://www.wikidata.org/entity/Q617 Padua Point(11.877777777 45.406388888) NaN
3001 http://www.wikidata.org/entity/Q94997948 Marcella Continanza http://www.wikidata.org/entity/Q52649 Roccanova Point(16.2 40.216666666) NaN
3002 http://www.wikidata.org/entity/Q93338246 Q93338246 http://www.wikidata.org/entity/Q13395 Viterbo Point(12.104166666 42.418611111) NaN
3139 http://www.wikidata.org/entity/Q82023870 Xanthos http://www.wikidata.org/entity/Q4951156 Sicily Point(14.266666666 37.566666666) NaN
3140 http://www.wikidata.org/entity/Q94695165 Giuseppe Borioni http://www.wikidata.org/entity/Q3415 Ancona Point(13.516666666 43.616666666) NaN
3141 http://www.wikidata.org/entity/Q84138681 Q84138681 http://www.wikidata.org/entity/Q220 Rome Point(12.482777777 41.893055555) NaN
3142 http://www.wikidata.org/entity/Q97441221 Si. Gui. da Pistoia http://www.wikidata.org/entity/Q13376 Pistoia Point(10.916666666 43.933333333) NaN
3143 http://www.wikidata.org/entity/Q97480621 Bonodico da Lucca http://www.wikidata.org/entity/Q13373 Lucca Point(10.516666666 43.85) NaN
3144 http://www.wikidata.org/entity/Q97971242 Cola di Alessandro http://www.wikidata.org/entity/Q3437 Perugia Point(12.3888 43.1121) NaN
3145 http://www.wikidata.org/entity/Q97974535 Fino d'Arezzo http://www.wikidata.org/entity/Q13378 Arezzo Point(11.878055555 43.463055555) NaN
3146 http://www.wikidata.org/entity/Q97992833 Mino da Colle http://www.wikidata.org/entity/Q91192 Colle di Val d'Elsa Point(11.126666666 43.4225) NaN
3147 http://www.wikidata.org/entity/Q98102625 Attaviano http://www.wikidata.org/entity/Q3437 Perugia Point(12.3888 43.1121) NaN
3148 http://www.wikidata.org/entity/Q98102843 Schiatta Pallavillani http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) NaN
3149 http://www.wikidata.org/entity/Q98102965 Q98102965 http://www.wikidata.org/entity/Q2044 Florence Point(11.254166666 43.771388888) NaN
3150 http://www.wikidata.org/entity/Q98103344 Luporo da Lucca http://www.wikidata.org/entity/Q13373 Lucca Point(10.516666666 43.85) NaN

3198 rows × 6 columns

Where poets are born

Find the 5 cities with most poets, sorted from most to least.

  • use groupby and sort_values methods

Show solution
[13]:
# write here


[13]:
placeLabel
Rome        198
Florence    165
Milan       121
Naples      113
Venice       94
Name: subj, dtype: int64

Duplicated poets

Find first 10 duplicated poets

Show solution
[14]:
# write here


[14]:
subjLabel
Giambattista Andreini    4
Eliseo Calenzio          4
Alojz Rebula             4
Sosiphanes               4
Giuseppe Carpani         3
Aulus Gellius            3
Tommaso Grossi           3
Giovanni della Casa      3
Fulvio Caccia            2
Rio Di Maria             2
Name: subj, dtype: int64
[ ]: