# Track a Turtle with WipperSnapper ## Overview https://www.youtube.com/watch?v=RSMtIRJooxA Cujo the turtle loves to dance. She also likes to sleep. What if we want to know when she does each of her activities? With a passing-by visual observation, it’s not always obvious. What if we could track her movement day and night and see for ourselves? Now, what if we could do all of that without writing a single line of code? We can with [WipperSnapper](https://learn.adafruit.com/quickstart-adafruit-io-wippersnapper)! ![](https://cdn-learn.adafruit.com/assets/assets/000/105/266/medium800/sensors_cujo_animated.png?1633713610) Using an [Adafruit Funhouse](https://www.adafruit.com/product/4985) and a [PIR motion sensor](https://www.adafruit.com/product/4871), we’ll track the movement of Cujo the turtle. Then we’ll analyze and visualize the data we’ve gathered to try and make sense of the results! ![](https://cdn-learn.adafruit.com/assets/assets/000/105/187/medium800/sensors_IMG_9258.jpg?1633627521) Wanna see what times of the day Cujo moved the most over the course of a week? Spoiler alert! The results are below. ![](https://cdn-learn.adafruit.com/assets/assets/000/105/371/medium800/projects_Screen_Shot_2021-10-12_at_11.57.29_AM.png?1634054283) Info: **Prerequisite Guide:** **WipperSnapper**  is an interface for [Adafruit IO, our incredibly easy-to-use IoT platform](https://learn.adafruit.com/welcome-to-adafruit-io/what-is-adafruit-io), designed to turn any WiFi-capable board into an IoT device without programming a single line of code. If you've never used WipperSnapper, click below to read through the Quickstart WipperSnapper guide before continuing. [Quickstart: Adafruit IO WipperSnapper](https://learn.adafruit.com/quickstart-adafruit-io-wippersnapper) ## Project materials Adafruit products: ### Adafruit FunHouse - WiFi Home Automation Development Board [Adafruit FunHouse - WiFi Home Automation Development Board](https://www.adafruit.com/product/4985) Home is where the heart is...it's also where we keep all our electronic bits. So why not wire it up with sensors and actuators to turn our house into an electronic wonderland. Whether it's tracking the environmental temperature and humidity in your laundry room, or notifying you when... Out of Stock [Buy Now](https://www.adafruit.com/product/4985) [Related Guides to the Product](https://learn.adafruit.com/products/4985/guides) ![Top-down video of Adafruit Funhouse PCB. The TFT display shows a data readout, and the NeoPixel LEDs glow rainbow colors.](https://cdn-shop.adafruit.com/product-videos/640x480/4985-00.jpg) ### Breadboard-friendly Mini PIR Motion Sensor with 3 Pin Header [Breadboard-friendly Mini PIR Motion Sensor with 3 Pin Header](https://www.adafruit.com/product/4871) PIR sensors are used to detect motion from pets/humanoids from about 5 meters away (possibly works on zombies, not guaranteed). This sensor is much smaller than most PIR modules, which makes it great for unobtrusive projects. It's also fully-contained - only needs power and ground, and... In Stock [Buy Now](https://www.adafruit.com/product/4871) [Related Guides to the Product](https://learn.adafruit.com/products/4871/guides) ![Topdown video of 3-pin PIR sensor assembled onto a breadboard. A hand passes over the sensor, and a blue LED to light up.](https://cdn-shop.adafruit.com/product-videos/640x480/4871-04.jpg) ### USB Type A to Type C Cable - approx 1 meter / 3 ft long [USB Type A to Type C Cable - approx 1 meter / 3 ft long](https://www.adafruit.com/product/4474) As technology changes and adapts, so does Adafruit. This   **USB Type A to Type C** cable will help you with the transition to USB C, even if you're still totin' around a USB Type A hub, computer or laptop. USB C is the latest industry-standard connector for... In Stock [Buy Now](https://www.adafruit.com/product/4474) [Related Guides to the Product](https://learn.adafruit.com/products/4474/guides) ![Angled shot of a coiled black, USB-C to USB-A cable.](https://cdn-shop.adafruit.com/640x480/4474-02.jpg) ### 5V 2A Switching Power Supply w/ USB-A Connector [5V 2A Switching Power Supply w/ USB-A Connector](https://www.adafruit.com/product/1994) Our 5V 2A USB power adapter is the perfect choice for powering single-board computers like Raspberry Pi, BeagleBone, or anything else that's power-hungry! This adapter was specifically designed to provide 5.25V, not 5V, but we still call it a 5V USB adapter. We did this on purpose to... In Stock [Buy Now](https://www.adafruit.com/product/1994) [Related Guides to the Product](https://learn.adafruit.com/products/1994/guides) ![5V 2A Switching Power Supply with USB-A Connector](https://cdn-shop.adafruit.com/640x480/1994-01.jpg) ### Premium Female/Male 'Extension' Jumper Wires - 20 x 3" [Premium Female/Male 'Extension' Jumper Wires - 20 x 3"](https://www.adafruit.com/product/1953) These Female/Male 'extension' jumper wires for making wire harnesses or jumpering between headers on PCB's. These premium jumper wires are 3" (75mm) long and come in a 'strip' of 20 (2 pieces of each of ten rainbow colors). They have 0.1" male header... In Stock [Buy Now](https://www.adafruit.com/product/1953) [Related Guides to the Product](https://learn.adafruit.com/products/1953/guides) ![Angled shot of Premium Female/Male 'Extension' Jumper Wires - 20 x 3](https://cdn-shop.adafruit.com/640x480/1953-02.jpg) Other materials: - Wooden skewers (found at the dollar store) - Tape # Track a Turtle with WipperSnapper ## Add the Mini PIR Sensor ## Align the Polarity Adding the mini PIR sensor to the FunHouse is pretty simple, you just need to check the polarity. Look for the + symbol on the PIR sensor's PCB and match it up with the + symbol on the front side of the FunHouse board's PIR row. ![leds_IMG_1165.jpg](https://cdn-learn.adafruit.com/assets/assets/000/101/902/medium640/leds_IMG_1165.jpg?1619628094) ![leds_IMG_1166.jpg](https://cdn-learn.adafruit.com/assets/assets/000/101/903/medium640/leds_IMG_1166.jpg?1619628111) ## Insert Sensor Align the pins with the socket holes on the front side of the board. The first time you insert the sensor the fit is tight, but just apply firm down ward pressure while wiggling the board a little bit and it will go in just fine. ![leds_IMG_1167.jpg](https://cdn-learn.adafruit.com/assets/assets/000/101/904/medium640/leds_IMG_1167.jpg?1619628259) ![leds_IMG_1168.jpg](https://cdn-learn.adafruit.com/assets/assets/000/101/905/medium640/leds_IMG_1168.jpg?1619628347) ![](https://cdn-learn.adafruit.com/assets/assets/000/101/906/medium800/leds_IMG_1169.jpg?1619628377) # Track a Turtle with WipperSnapper ## Set up FunHouse, Feeds and Actions Step 1 is to get your Funhouse set up and online in the **[Adafruit IO WipperSnapper Devices page](https://io.adafruit.com/devices). Follow the instructions in the [FunHouse product learn guide, on the WipperSnapper Setup page](https://learn.adafruit.com/adafruit-funhouse/wippersnapper-setup). ** ![](https://cdn-learn.adafruit.com/assets/assets/000/105/190/medium800/sensors_Screen_Shot_2021-09-29_at_4.58.16_PM.png?1633629764) ## Set up the PIR sensor + LEDs We'll get then PIR motion sensor setup within WipperSnapper, and then add the DotStar LED lights for output. - From the WipperSnapper page, click "New Component" - Search for "PIR Sensor" then select the PIR sensor component ![](https://cdn-learn.adafruit.com/assets/assets/000/138/115/medium640/customer___partner_projects_pmJMVyvRmD.png?1751462090) - Name the sensor - Select "PIR Sensor" for the PIR Sensor pin - choose the "On Change" option for the return interval. This means that the sensor will ping out data only when it is triggered (aka when Cujo the turtle moves) ![sensors_Screen_Shot_2021-09-29_at_5.00.23_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/191/medium640/sensors_Screen_Shot_2021-09-29_at_5.00.23_PM.png?1633630432) - Next we'll add the DotStar LEDs. Click the **New Component** button again. - Search for **DotStar** and select the component. - On the configuration page leave the default pins selected, but change the **Number of Pixels**  from 1 to **5**. The **Color Order** should be **BRG**. ![](https://cdn-learn.adafruit.com/assets/assets/000/138/116/medium640/customer___partner_projects_A0SCOcDn53.png?1751463213) - Your WipperSnapper page should now look something like this (click on image to enlarge) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/117/medium640/customer___partner_projects_4HPwRP7JSN.png?1751463449) ## Create a Feed for the PIR sensor Now that the FunHouse is connected to WipperSnapper and the PIR sensor and LED are set up, it's time to create a feed. Why? The sensor data needs a home. When the sensor is tripped, we want to send a message to this new feed documenting that movement was detected at a given time. - In the top pane, click "Feeds" - Then click "New Group" - Create a new feed group and call it "WipperSnapper" or whatever you'd like ![](https://cdn-learn.adafruit.com/assets/assets/000/138/118/medium640/customer___partner_projects_I8hjX3Guuc.png?1751463663) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/119/medium640/customer___partner_projects_pcBqK36nIk.png?1751463742) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/120/medium640/customer___partner_projects_o8MMRV0kEZ.png?1751463977) - Click the group name in the feeds list page to go there before creating a feed, but in future you can use the + button at the end of the row to directly add a feed to the group. - Within the new feed group, click "new feed" and enter the details about the feed. - Click "create" ![](https://cdn-learn.adafruit.com/assets/assets/000/138/121/medium640/customer___partner_projects_dAiNi0a9y2.png?1751464177) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/122/medium640/customer___partner_projects_eLdJuxxrQ7.png?1751464297) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/123/medium640/customer___partner_projects_0OhQagFbqr.png?1751464372) ## Set up the Actions Now that we have a home for our data, we need to point the data to that home when certain events happen. Now it's time to define those events with actions. Here are the actions we'll create: - Send a message "Turtle moved!" to the motion sensor feed each time the sensor has been activated. - Send a message "Turtle is still" to the motion sensor feed when there is no longer any movement. - Set the LED to ON when the sensor is triggered - Set the LED to OFF when the sensor is not triggered. - In the top navigation pane, click "Actions" - A searchable list of actions appears, with status information at the end of each row. - Click "New Action" in the top left of the page - Choose a name and optional description then click Create. ![](https://cdn-learn.adafruit.com/assets/assets/000/138/173/medium640/customer___partner_projects_X9ZGhQJziY.png?1751912027) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/174/medium640/customer___partner_projects_dz7pouqtP8.png?1751912105) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/175/medium640/customer___partner_projects_3LpVEYqGfT.png?1751912279) First up we want to send a message "Turtle moved!" to the motion sensor feed each time the sensor has been activated. Drag a trigger block, the one which says " **When gets data matching `=` `0`**", from the toolbox and into the `Triggers:` section of the workspace. Update the feed dropdown to select the `motion sensor`, and change the operator from equals (`=`) to instead be "greater than" (`>`). Next add a **Set Feed** block to the `Actions:` section of the root block on the diagram. Alter the feed to point to the "Motion Sensor Activated?" feed, and the value to be `Turtle Moved!`. ![](https://cdn-learn.adafruit.com/assets/assets/000/138/177/medium640thumb/customer___partner_projects_chrome_eMWZVB7qZ6.jpg?1751913177) Your diagram should now look like this: - **Triggers:** When `motion sensor` gets data matching `greater than` `0` - **Actions:** `Set Feed` `Motion sensor activated?` to value `Turtle moved!` - Hit save, and choose Enable and Save (asked the first time, or if the action is disabled when saving). ![](https://cdn-learn.adafruit.com/assets/assets/000/138/178/medium640/customer___partner_projects_M56pbM5Vmw.png?1751913320) Create another action for when the turtle is still: - **Triggers:** When `motion sensor` gets data matching `equals` `0` - **Actions:** `Set Feed` `Motion sensor activated?` to value `Turtle is still` - Hit save, and choose Enable and Save (asked the first time, or if the action is disabled when saving). ![](https://cdn-learn.adafruit.com/assets/assets/000/138/179/medium640/customer___partner_projects_ahWYl9Dgs0.png?1751913810) **Create two more reactive triggers for the LED:** - Create a new action for turning the LEDs on, almost duplicating the previous action. - **Triggers:** When `motion sensor` gets data matching `greater than` `0` - **Actions:**  `Set Feed` `FunHouse DotStars` to value `#FFFFFF` - Hit save (and choose enable if asked) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/180/medium640/customer___partner_projects_ot96Ov4K87.png?1751914350) - Create the new "LED off" action - **Triggers:**  When `motion sensor` gets data matching `equals` `0` - **Actions:**  `Set Feed` `FunHouse DotStars` to value `#000000` - Hit save (and enable if asked) ![](https://cdn-learn.adafruit.com/assets/assets/000/138/218/medium640/proximity_AlFNwEu8QH.png?1751986896) **Why create LED actions?** This lets us know if the motion sensor is properly working when in the calibration step which is coming up soon. Next up we'll set up the dashboard so we can get some visual feedback on the data. # Track a Turtle with WipperSnapper ## Set up the Dashboard To visualize and keep tabs on Cujo, we'll need to create a d **ashboard. ** This will be an easy way to access the results from the feed and triggers we just set up. - In the top pane, click "Dashboards" - Next click "view all" - Click "New Dashboard" - Enter the title and description for the dashboard ![sensors_Screen_Shot_2021-10-08_at_12.26.13_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/228/medium640/sensors_Screen_Shot_2021-10-08_at_12.26.13_PM.png?1633711185) ![sensors_Screen_Shot_2021-10-08_at_12.26.20_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/229/medium640/sensors_Screen_Shot_2021-10-08_at_12.26.20_PM.png?1633711201) ![sensors_Screen_Shot_2021-10-08_at_12.27.06_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/230/medium640/sensors_Screen_Shot_2021-10-08_at_12.27.06_PM.png?1633711216) Now we're in the Dashboard creator! - Click the gear icon then click the "create new block" option - These are all the different blocks available. ![sensors_Screen_Shot_2021-10-08_at_12.27.26_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/234/medium640/sensors_Screen_Shot_2021-10-08_at_12.27.26_PM.png?1633711376) ![sensors_Screen_Shot_2021-10-08_at_12.44.37_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/236/medium640/sensors_Screen_Shot_2021-10-08_at_12.44.37_PM.png?1633711541) ## Create a line chart graph This is helpful for seeing Cujo's movement patterns over time. - From the different blocks, click on the one entitled "Line Chart" - From your FunHouse feeds, select "motion sensor" for the chart feed - Name the chart - Create a time range for the data we would like to see. - Label the axes - Set the min and max value for the Y-axis - Click "Create block" - Hit "Save Layout" ![sensors_Screen_Shot_2021-10-08_at_12.44.25_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/245/medium640/sensors_Screen_Shot_2021-10-08_at_12.44.25_PM.png?1633711943) ![sensors_Screen_Shot_2021-10-08_at_12.28.33_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/247/medium640/sensors_Screen_Shot_2021-10-08_at_12.28.33_PM.png?1633712020) ![sensors_Screen_Shot_2021-10-08_at_12.58.01_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/249/medium640/sensors_Screen_Shot_2021-10-08_at_12.58.01_PM.png?1633712326) ![sensors_Screen_Shot_2021-10-08_at_12.58.20_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/250/medium640/sensors_Screen_Shot_2021-10-08_at_12.58.20_PM.png?1633712480) ## Create a stream for the data feed This is helpful for seeing exact data points. Aka what time exactly did Cujo move? - Create another new block from the gear icon. - Select the "Stream" block - For the feed, choose the feed we manually created earlier from the WipperSnapper feed group called "Motion sensor activated"? - Create a name for the block as well as a time range for the data we would like to see. - Click "Create block" and save the layout ![sensors_Screen_Shot_2021-10-08_at_12.44.31_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/255/medium640/sensors_Screen_Shot_2021-10-08_at_12.44.31_PM.png?1633712741) ![sensors_Screen_Shot_2021-10-08_at_12.31.23_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/256/medium640/sensors_Screen_Shot_2021-10-08_at_12.31.23_PM.png?1633712779) ![sensors_Screen_Shot_2021-10-08_at_12.33.59_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/257/medium640/sensors_Screen_Shot_2021-10-08_at_12.33.59_PM.png?1633712803) ![sensors_Screen_Shot_2021-10-08_at_1.06.55_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/258/medium640/sensors_Screen_Shot_2021-10-08_at_1.06.55_PM.png?1633712905) And voila! There's our gorgeous dashboard. We can change the layout of the blocks by hitting the gear icon and dragging the blocks around, then saving the layout. **Don't see any data?** That's ok, try refreshing the page. If there's still nothing that's probably because we haven't collected any data yet! (These screenshots are showing data that's been collected over the last couple of days of this writing). ![](https://cdn-learn.adafruit.com/assets/assets/000/105/264/medium800/sensors_Screen_Shot_2021-10-08_at_1.14.22_PM.png?1633713282) Now it's time to place the sensor near Cujo's habitat and start collecting some delicious data! # Track a Turtle with WipperSnapper ## Sensor Placement and Calibration One fun fact about PIR motion sensors, they are infrared-based and are not able to see or detect movement through glass. How do we solve this problem? By placing the sensor over the tank. This works quite well because the glass blocks all other movements when pesky humans walk by or come to observe Cujo.  Using some wooden skewers from the dollar store and some Scotch tape, I was able to easily hang the FunHouse and PIR sensor over Cujo's tank. ## Calibration The next obstacle? I noticed the sensor wasn't picking up Cujo's movements at the very top of the tank. The sensor needed to be closer to Cujo.  - With [some short extension jumper cables](https://www.adafruit.com/product/1953), we can extend the sensor long enough to register Cujo's movement. ![sensors_extendo.png](https://cdn-learn.adafruit.com/assets/assets/000/105/271/medium640/sensors_extendo.png?1633715204) ![sensors_IMG_9214.jpg](https://cdn-learn.adafruit.com/assets/assets/000/105/272/medium640/sensors_IMG_9214.jpg?1633715229) (Note, I was using a toaster oven rack at first to hold up the FunHouse before switching to the much more ideal wooden skewers. Now I can use my toaster oven again!) ![](https://cdn-learn.adafruit.com/assets/assets/000/105/267/medium800/sensors_IMG_9256.jpg?1633714455) That's more like it! Now it able to register Cujo's movement more frequently.  ## Testing...Testing Next, let's double-check the sensor and the dashboard are set up correctly. Power on the Funhouse using a [5V 2A power supply](https://www.adafruit.com/product/1994) with a [USB C cable](https://www.adafruit.com/product/4474). Now wave your hand in front of the motion sensor. The onboard red led should blink on and off. Additionally, the dashboard should have recorded the hand wave as turtle movement. If the LED is not blinking or the data isn't showing up on the dashboard, double-check the FunHouse feeds, triggers and dashboard were all set up properly in the earlier sections of this guide. Do not move on until the led blinks properly and the dashboard is collecting accurate data otherwise the project won't be collecting anything useful. ![](https://cdn-learn.adafruit.com/assets/assets/000/105/265/medium800thumb/sensors_motion_sensor.jpg?1633713546) ## Just walk away Ok now that everything is in working order, place the sensor in an ideal space above the tank and go away. It's time to let Cujo do her thing! The next step is to monitor, analyze and visualize the data. It's time to be a scientist and watch Cujo... from a computer. ![](https://cdn-learn.adafruit.com/assets/assets/000/105/273/medium800/sensors_IMG_9267_2.jpg?1633715365) # Track a Turtle with WipperSnapper ## Data Monitoring, Analysis and Visualization ![](https://cdn-learn.adafruit.com/assets/assets/000/105/275/medium800/sensors_turtle_annotation.png?1633715949 note: LED I/O block is not necessary) It will be tempting to watch the dashboard in the first day or two but after a couple of days of data collection, we can start to see a bigger picture of Cujo's movement patterns. Make sure to distinguish the data recorded from the setup and calibration as opposed to the data from when the sensor was all set up and you walked away. ![](https://cdn-learn.adafruit.com/assets/assets/000/105/276/medium800/sensors_Screen_Shot_2021-10-08_at_12.58.20_PM.png?1633716044) And it worked! Look at that wonderful turtle data! What does it mean? A couple of days is neat and all but how about waiting a whole week? You can stop here but going further into this bonus section will unlock some great turtle mysteries. Slow and steady wins the race... ## Bonus section: use Google Sheets to analyze a week of turtle data Ok, it's been a week. Suppose we'd like to see more than just the times that Cujo moved? Let's inquire about: - **What times of the day did Cujo move the most?** - **What days did Cujo move more than other days?** These questions may give us more insight into her movement patterns than the simple line chart.  We can export the data from Adafruit.io and import it into Google Sheets to do some analysis and answer these questions. ## Download feed data - Go to your feeds and select the "Motion sensor activated" feed we set up earlier. - Click the "Download All Data" button  - Click "Download as CSV" - Next hit "click to refresh" - Now click "Link" to download the file. ![sensors_Screen_Shot_2021-10-08_at_2.10.33_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/277/medium640/sensors_Screen_Shot_2021-10-08_at_2.10.33_PM.png?1633716833) ![sensors_Screen_Shot_2021-10-08_at_2.11.11_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/279/medium640/sensors_Screen_Shot_2021-10-08_at_2.11.11_PM.png?1633717116) ![sensors_Screen_Shot_2021-10-08_at_2.11.20_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/280/medium640/sensors_Screen_Shot_2021-10-08_at_2.11.20_PM.png?1633717151) ![sensors_Screen_Shot_2021-10-08_at_2.11.29_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/281/medium640/sensors_Screen_Shot_2021-10-08_at_2.11.29_PM.png?1633717191) ![sensors_Screen_Shot_2021-10-08_at_2.11.36_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/282/medium640/sensors_Screen_Shot_2021-10-08_at_2.11.36_PM.png?1633717220) ## Import feed data into Google Sheets - Go to [https://drive.google.com/](https://drive.google.com/) - You may have to create a free Gmail account if you don't already have one. - Create a new Google Sheets document and name it ![sensors_Screen_Shot_2021-10-08_at_2.23.08_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/288/medium640/sensors_Screen_Shot_2021-10-08_at_2.23.08_PM.png?1633717478) ![sensors_Screen_Shot_2021-10-08_at_2.24.02_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/289/medium640/sensors_Screen_Shot_2021-10-08_at_2.24.02_PM.png?1633717492) - Go to  **File \> Import** - Upload the CSV file we just downloaded from Adafruit.io - Select the file - Choose the option "Append to current sheet" for the import location. - Hit import data. - Watch as the turtle data floods your spreadsheet. Huzzah! ![sensors_Screen_Shot_2021-10-08_at_2.26.03_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/292/medium640/sensors_Screen_Shot_2021-10-08_at_2.26.03_PM.png?1633717704) ![sensors_Screen_Shot_2021-10-08_at_2.26.19_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/293/medium640/sensors_Screen_Shot_2021-10-08_at_2.26.19_PM.png?1633717882) ## Separating the day and time into separate columns  You may notice the time stamp for each data point includes both day and time. To analyze the data in the way that we'd like, it will be helpful to have separate columns for the day and the time. The day column will come in handy when we want to analyze which days Cujo moved the most. We don't so much care for the times she moved in this data set. The same goes for when we want to analyze which times of the day Cujo moved the most (we don't care which day it was). - Click on column d to highlight the entire date/time column. - In the toolbar go to **Data \> Split text to columns** - Now the time/date data is split into 3 columns: date, time, and time zone. (Time zone is not important for this project) ![sensors_Screen_Shot_2021-10-08_at_2.32.05_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/296/medium640/sensors_Screen_Shot_2021-10-08_at_2.32.05_PM.png?1633718268) ![sensors_Screen_Shot_2021-10-08_at_2.32.32_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/298/medium640/sensors_Screen_Shot_2021-10-08_at_2.32.32_PM.png?1633718354) ![sensors_Screen_Shot_2021-10-08_at_2.32.45_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/299/medium640/sensors_Screen_Shot_2021-10-08_at_2.32.45_PM.png?1633718380) ## Data Analysis Chart #1: Which times of the day did Cujo move the most during the week? For this data visualization, let's split the day up into 4 equal parts (in military time) - 00:00 - 05:59 - 06:00 - 11:59 - 12:00 - 17:59 - 18:00 - 23:59 - In a new column called "time portion" manually fill out 4 rows with each of these time segments. - The next column should be called "times moved" - Now enter this formula into the cell next to `00:00 - 05:59`: `=countifs(E2:E758,">= 0:00:00", E2:E758, "<= 05:59:59")/2` `` - This formula counts the times in column E that are between `00:00 - 05:59` then divides the resulting value by 2 (to remove the times that the sensor reset to the still state) - Replace `E758` with the location of the last cell in this column for you. - Now continue this process for the other three cells. ![sensors_Screen_Shot_2021-10-08_at_2.48.18_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/304/medium640/sensors_Screen_Shot_2021-10-08_at_2.48.18_PM.png?1633718920) ![sensors_Screen_Shot_2021-10-08_at_3.10.41_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/313/medium640/sensors_Screen_Shot_2021-10-08_at_3.10.41_PM.png?1633720283) ## Pie time Now that we know how many times Cujo moved during the 4 parts of the day, let's make a pie chart! - Now highlight both columns we just created. - In the toolbar, click  **insert \> chart** - Select one of the **pie chart** options (I like the 3D one) - The pie should fill with the selected data. - Feel free to add a title and rename any labels. - I decided to rename column G with each time frame's colloquial name for easier reference on the chart (morning, night etc.) ![sensors_Screen_Shot_2021-10-08_at_3.01.14_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/317/medium640/sensors_Screen_Shot_2021-10-08_at_3.01.14_PM.png?1633720352) ![sensors_Screen_Shot_2021-10-08_at_3.11.47_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/318/medium640/sensors_Screen_Shot_2021-10-08_at_3.11.47_PM.png?1633720400) ![sensors_Screen_Shot_2021-10-08_at_3.01.42_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/319/medium640/sensors_Screen_Shot_2021-10-08_at_3.01.42_PM.png?1633720444) ![sensors_Screen_Shot_2021-10-08_at_3.06.02_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/320/medium640/sensors_Screen_Shot_2021-10-08_at_3.06.02_PM.png?1633720523) ![sensors_Screen_Shot_2021-10-08_at_3.08.14_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/322/medium640/sensors_Screen_Shot_2021-10-08_at_3.08.14_PM.png?1633720548) That's one pretty pie! You can adjust the font and text settings in the graph editor. ![](https://cdn-learn.adafruit.com/assets/assets/000/105/372/medium800/projects_Screen_Shot_2021-10-12_at_11.57.29_AM.png?1634054468) ## Data Analysis Chart #2: Which days did Cujo move the most during the week? Following the same method as above, we can create a bar graph to show the days that Cujo moved the most. The formula used is slightly differnt this time: `=countifs(D2:D758,"2021-09-29") / 2` This spits out the number of times Cujo moved on the specified day For each cell, replace `2021-09-29` with the day you'd like to collect data for. ![sensors_Screen_Shot_2021-10-08_at_3.21.16_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/330/medium640/sensors_Screen_Shot_2021-10-08_at_3.21.16_PM.png?1633720955) ![sensors_Screen_Shot_2021-10-08_at_3.21.28_PM.png](https://cdn-learn.adafruit.com/assets/assets/000/105/331/medium640/sensors_Screen_Shot_2021-10-08_at_3.21.28_PM.png?1633720978) Chart it up with a bar graph and badda bing! ![](https://cdn-learn.adafruit.com/assets/assets/000/105/329/medium800/sensors_Screen_Shot_2021-10-08_at_3.18.40_PM.png?1633720817) ## Takeaways What patterns did you notice?  - Cujo liked to dance at night and sleep in the day. - She had a busy week to start, then got quite relaxed. - After feeding her, she seemed to calm down quite a bit. You can recreate this project for your own pet(s). Some ideas include: - Birds - Reptiles - Hampsters and gerbils - Guinea pigs - Dogs: could put a sensor in the kennel or crate if they sleep in there. Good luck uncovering something you didn't expect to discover about your pet with the power of WipperSnapper!   ## Featured Products ### Adafruit FunHouse - WiFi Home Automation Development Board [Adafruit FunHouse - WiFi Home Automation Development Board](https://www.adafruit.com/product/4985) Home is where the heart is...it's also where we keep all our electronic bits. So why not wire it up with sensors and actuators to turn our house into an electronic wonderland. Whether it's tracking the environmental temperature and humidity in your laundry room, or notifying you when... Out of Stock [Buy Now](https://www.adafruit.com/product/4985) [Related Guides to the Product](https://learn.adafruit.com/products/4985/guides) ### Breadboard-friendly Mini PIR Motion Sensor with 3 Pin Header [Breadboard-friendly Mini PIR Motion Sensor with 3 Pin Header](https://www.adafruit.com/product/4871) PIR sensors are used to detect motion from pets/humanoids from about 5 meters away (possibly works on zombies, not guaranteed). This sensor is much smaller than most PIR modules, which makes it great for unobtrusive projects. It's also fully-contained - only needs power and ground, and... In Stock [Buy Now](https://www.adafruit.com/product/4871) [Related Guides to the Product](https://learn.adafruit.com/products/4871/guides) ### USB Type A to Type C Cable - approx 1 meter / 3 ft long [USB Type A to Type C Cable - approx 1 meter / 3 ft long](https://www.adafruit.com/product/4474) As technology changes and adapts, so does Adafruit. This   **USB Type A to Type C** cable will help you with the transition to USB C, even if you're still totin' around a USB Type A hub, computer or laptop. USB C is the latest industry-standard connector for... In Stock [Buy Now](https://www.adafruit.com/product/4474) [Related Guides to the Product](https://learn.adafruit.com/products/4474/guides) ### 5V 2A Switching Power Supply w/ USB-A Connector [5V 2A Switching Power Supply w/ USB-A Connector](https://www.adafruit.com/product/1994) Our 5V 2A USB power adapter is the perfect choice for powering single-board computers like Raspberry Pi, BeagleBone, or anything else that's power-hungry! This adapter was specifically designed to provide 5.25V, not 5V, but we still call it a 5V USB adapter. We did this on purpose to... In Stock [Buy Now](https://www.adafruit.com/product/1994) [Related Guides to the Product](https://learn.adafruit.com/products/1994/guides) ### Premium Female/Male 'Extension' Jumper Wires - 20 x 3" [Premium Female/Male 'Extension' Jumper Wires - 20 x 3"](https://www.adafruit.com/product/1953) These Female/Male 'extension' jumper wires for making wire harnesses or jumpering between headers on PCB's. These premium jumper wires are 3" (75mm) long and come in a 'strip' of 20 (2 pieces of each of ten rainbow colors). They have 0.1" male header... In Stock [Buy Now](https://www.adafruit.com/product/1953) [Related Guides to the Product](https://learn.adafruit.com/products/1953/guides) ## Related Guides - [Adafruit FunHouse](https://learn.adafruit.com/adafruit-funhouse.md) - [No-Code WipperSnapper Water Detection](https://learn.adafruit.com/water-detection-with-wippersnapper.md) - [Creating FunHouse Projects with CircuitPython](https://learn.adafruit.com/creating-funhouse-projects-with-circuitpython.md) - [Using the Adafruit FunHouse with Home Assistant](https://learn.adafruit.com/using-the-adafruit-funhouse-with-home-assistant.md) - [No-Code Room Occupancy Status ](https://learn.adafruit.com/no-code-room-occupancy-status.md) - [Using ItsaSNAP for HomeKit PIR Motion Detection](https://learn.adafruit.com/itsasnap-homekit-pir-motion-detection.md) - [No-Code WipperSnapper IoT Power Switch Outlet](https://learn.adafruit.com/no-code-wippersnapper-iot-power-switch-outlet.md) - [FunHouse Motion Detecting Lights with LIFX Bulbs](https://learn.adafruit.com/funhouse-motion-detecting-lighting-for-lifx-bulbs.md) - [Pet Bowl Water Level Sensing](https://learn.adafruit.com/pet-bowl-water-level-sensing-with-the-funhouse-and-home-assistant.md) - [Quickstart: Adafruit IO WipperSnapper ](https://learn.adafruit.com/quickstart-adafruit-io-wippersnapper.md) - [No-Code WipperSnapper Action Counter](https://learn.adafruit.com/no-code-wippersnapper-action-counter.md) - [FunHouse 3D Printed Stand](https://learn.adafruit.com/funhouse-3d-printed-stand.md) - [FunHouse IoT Fume Extractor and Air Quality Sensor](https://learn.adafruit.com/funhouse-fume-extractor-iot-air-quality-sensor.md) - [CircuitPython Web Workflow Code Editor Quick Start](https://learn.adafruit.com/getting-started-with-web-workflow-using-the-code-editor.md) - [FunHouse Mail Slot Detector](https://learn.adafruit.com/funhouse-mail-slot-detector.md) - [Motion Activated Outlet with the Adafruit FunHouse](https://learn.adafruit.com/motion-activated-outlet-with-the-adafruit-funhouse.md)