John Goliash

Data analyst · a practice dashboard

391 villagers, checked and charted.

My job is to make sure the numbers are right, then make them easy to read. Here I do it for fun, with every villager in Animal Crossing: New Horizons: who they are, who players want most, and where the data disagrees with itself. Click any bar to filter the whole page. Then scroll to the end and try it with your own spreadsheet.

See the dashboard How to use this page

Data: the villager file and the Nook Market wish list behind Jesse Mostipak’s Kaggle notebook, a fan tier list, and a second copy of the villagers from TidyTuesday (VillagerDB) to check it against. Every number on this page is worked out by your own browser, live.

Animal Crossing villager data reports dashboard illustration

How to use this page

Six steps, in plain words. You can’t break anything, and nothing you type or open here is saved.

  1. Read the checks first

    A tick means that part of the data looks right. An ! means look closer before you trust a number.

  2. Narrow it down

    Pick a species, personality, hobby, month or gender at the top of the dashboard. Every chart below changes to match.

  3. Tap a bar

    Tap a bar in the species, personality, hobby or birthday charts and the whole page filters to it. Tap it again, or press Clear filters, to go back.

  4. See the exact numbers

    Hover over or tap any bar for its number. Every chart also has Show as a table underneath.

  5. Have some fun

    Look up your birthday twin, press Shuffle to meet a villager, or search the full table at the bottom.

  6. Try your own data

    Save a spreadsheet as a CSV file and open it in Explore your own data. It stays on your device.

First, check the data

Before I chart anything, I look for holes, and I check that the files really fit together. These checks ran a moment ago, on this page.

  • Turn on JavaScript to run the checks and the dashboard.

The dashboard

Pick a filter, or click a bar. Every chart, number and list below follows the same filter.

Gender

Who players want most

Most wished-for villagers

Nook Market’s wish list, May 2020. #1 is the villager most players wanted.

Average popularity by species

Popularity score: 100 for the most wished-for villager, 0 for the least. Number of villagers in brackets. Each face is that species’ most wished-for villager.

Average popularity by personality

Do two popularity lists agree?

Average wish-list score for each tier of a fan tier list.

Who they are

Villagers by species

Each face is that species’ most wished-for villager.

Villagers by personality

Villagers by hobby

Clothing styles

Each villager has two style picks; a villager counts once per style.

Favorite colors

Each villager has two favorite colors; a villager counts once per color.

Birthdays and words

Birthdays by month

Top 10 favorite songs

Catchphrase length

First letter of their names

Birthday calendar

Every square is a day of the year. The darker the green, the more villagers share it. Tap a square, or look up your own birthday.

Meet a villager

One at random, from whoever your filters leave in.

Villager pictures are the game’s own icons and photos, © Nintendo, from the fan-made ACNH API. Each one is found by the villager’s ID in the data (the Filename column), not picked by hand.

What the data says

The findings I’d put at the top of a report. Worked out from every villager, whatever the filters say.

    Every villager

    The table behind every chart. Search it, or click a column name to sort.

    Explore your own data

    Open a spreadsheet saved as CSV, and this page checks it and charts it the same way. Your file never leaves your computer. It isn’t uploaded, stored or saved, by me or anyone. Reload the page and it’s gone.

    1. Open your file. Choose it, drop it in the box, or paste the cells.
    2. Read the checks. They point out blanks, copies and odd values.
    3. Make a chart. Pick what to group by (like Region), then what to measure (a count of rows, or the sum or average of a number column).
    4. Keep it. Press Download as CSV to save the chart’s numbers, or Forget this data when you’re done.
    How do I save my spreadsheet as a CSV?
    • Excel: File → Save As → choose CSV UTF-8 (Comma delimited).
    • Google Sheets: File → Download → Comma-separated values (.csv).
    • Numbers on a Mac: File → Export To → CSV.
    • No file handy? Copy the cells in your spreadsheet, header row included, and use “Or paste rows from a spreadsheet” below.

    The first row should be the column names. One table per file works best.

    Drop a CSV file here

    or

    Or paste rows from a spreadsheet