User Profile
confooseddesi89
Copper Contributor
Joined Jun 17, 2023
User Widgets
Recent Discussions
Too large dataset - extract data within date range
I have a large dataset. Here is a sample of what the data look like: id id_2 survey type date from to created updated question_num question answer 4570091 6793 91 Nutrition 5/21/2022 0:00 5/21/2022 15:00 5/28/2022 2:00 5/21/2022 0:12 5/21/2022 15:48 159 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Bottled or pre- made sugary tea or coffee drinks (for example, Snapple ice tea or Starbucks Frappuccino) 0 4570091 6793 91 Nutrition 5/21/2022 0:00 5/21/2022 15:00 5/28/2022 2:00 5/21/2022 0:12 5/21/2022 15:48 160 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Sports drinks 0 4570091 6793 91 Nutrition 5/21/2022 0:00 5/21/2022 15:00 5/28/2022 2:00 5/21/2022 0:12 5/21/2022 15:48 161 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Caffeinated energy drinks 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 161 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Caffeinated energy drinks 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 160 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Sports drinks 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 159 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Bottled or pre- made sugary tea or coffee drinks (for example, Snapple ice tea or Starbucks Frappuccino) 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 155 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… 100% fruit juice 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 158 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Diet soft drinks and all other artificially sweetened drinks 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 156 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Sweetened juice drinks (for example, fruit ades, lemonade, punch, and orange drinks) 0 4564743 6794 91 Nutrition 5/20/2022 0:00 5/20/2022 12:00 5/26/2022 23:00 5/20/2022 0:10 5/20/2022 12:46 157 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Regular soft drinks (soda pop) 0 4556257 6796 91 Nutrition 5/18/2022 0:00 5/18/2022 15:00 5/25/2022 2:00 5/18/2022 0:11 5/18/2022 22:07 161 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Caffeinated energy drinks 0 4556257 6796 91 Nutrition 5/18/2022 0:00 5/18/2022 15:00 5/25/2022 2:00 5/18/2022 0:11 5/18/2022 22:07 160 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Sports drinks 0 4556257 6796 91 Nutrition 5/18/2022 0:00 5/18/2022 15:00 5/25/2022 2:00 5/18/2022 0:11 5/18/2022 22:07 159 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Bottled or pre- made sugary tea or coffee drinks (for example, Snapple ice tea or Starbucks Frappuccino) 0 4556257 6796 91 Nutrition 5/18/2022 0:00 5/18/2022 15:00 5/25/2022 2:00 5/18/2022 0:11 5/18/2022 22:07 158 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Diet soft drinks and all other artificially sweetened drinks 0 4587204 6795 91 Nutrition 5/27/2022 0:00 5/24/2022 10:00 5/30/2022 21:00 5/24/2022 0:11 5/27/2022 19:08 161 Please choose a number between 0 and 10 where 0 is not at all and 10 is quite a bit How much would you say you like the taste and generally enjoy drinking… Caffeinated energy drinks 0 There are too many rows for Excel to display; when I open the file, I receive the message "this data set is too large for the excel grid. If you save this workbook, you'll lose data that wasn't loaded." I need to work with the data in Excel before importing it into my statistical software, so this is an issue. However, I don't need all the data, only the dates where the column "date" is from 7/17/2022 0:00 onward (the date column ranges from August of 2021 to April of 2023). I've tried using a PivotTable to extract this dataset with only these dates, but even with Googling how to use them, I got stuck as I have no experience with them. Can anyone assist? Thanks4.5KViews0likes11Comments
Recent Blog Articles
No content to show