Data is Fun

Where data is fun.

February 25, 2020

NYC Locations Providing Seasonal Flu Vaccines Visualized

Source Data: https://data.cityofnewyork.us/Health/New-York-City-Locations-Providing-Seasonal-Flu-Vac/w9ei-idxz

2016 Data showing places one can go for a Flu Vaccine in NYC.

February 22, 2020

NYC Data Week 2020

Friday, February 28 – Saturday, March 7, 2020

Be sure to check out the annual weekly event. The official site is here.

Most of the events are free, or low cost.

The list of events can be found here. It’s nice that the information can be filtered, and it makes it easy to register for events. There is a “Select View button” (in the upper left hand corner) that makes it easier to view the data. However, I found it difficult to compare the descriptions across events.

A favorite event during open data week is BETA NYC’s School of Data. School of Data is a one day event (on Sat. March 7th). It’s a fun way to meet others interested in data and/or NYC and learn too. I’d describe it as low cost. It’s not cheap, or free, but compared to conferences that can cost $1000+ it’s a $55 ticket .

Excel Tip: Transpose Data

Flip your data with transpose

  1. Highlight the data range
  2. Copy the data
  3. Right Click on the cell where you want to paste the data
  4. Choose Paste special (use the mouse to paste special)
  5. Click on Transpose

Let’s See it in action:

(Note: there is also an Excel Function =TRANSPOSE(), That does the same thing but via formula)

February 15, 2020

Excel Tip: Viewing Formulas

To switch between viewing formulas use:

CTRL + ~

February 08, 2020

Excel Tip: The Format Painter Tool and Double Clicking.

Excel Paintbrush

What does the Format Painter do?

It allows you to copy the style (color, font etc.) and apply the styling of the cell to another cell. It just copies the style – not the text.


Where do I find it?

The format painter tool is available in the upper left corner of the ‘Home’ Tab in Microsoft Excel. You might already be familiar with single clicking on it.


What does the Tool do?

It allows you to copy the formatting from one cell (or a range of cells) to another cell (or range of cells). It’s especially useful if you have multiple formats applied to cells that you want to repeat else where. It’s copy and paste, but it only copies the format not the actual content of the cell. For example, if you had a cell formatted BOLD, with a blue cell color you wouldn’t have to repeat all the steps multiple times.

What’s the difference between single and double clicking?

SINGLE CLICK:

When you single click on the format painter (image that looks like a paint brush) it allows you to copy the cell format to one or more contiguous cells ( cells that are next to one another).

DOUBLE CLICK:

When you double click on the painter you can copy the format to non-contiguous cells. So if there are gaps in the areas you want to format use the double click. NOTE: Excel will continuously apply the format until you click on the format painter icon again.

See it in action:

January 31, 2020

Requesting NYC Data

Sometimes data you want isn’t available. Here’s one way of obtaining it in NYC: https://opendata.cityofnewyork.us/engage/ .