如何计算和记录具有特定月/年值的工作表中的行数(How can I count and log the number of rows in a sheet with a specific month/year value)

 我已下载了一个数据集，其中详细列出了1979年1月至2004年12月期间在英格兰报告的所有车祸 - 该文件采用csv格式，可以理解为相当大（确切地说是6,224,199行）。 由于文件的大小超过了Excel 2010可以处理的行数，因此我必须将文件拆分为较小的文件，以便在Excel中一次打开它。 我尝试使用Notepad和Notepad ++，但记事本崩溃，而Notepad ++拒绝打开如此大的（720MB）文件。 我考虑使用像Delimit这样的Excel 替代品 ，但它不支持宏。 现在，忽略大小问题，我需要计算每个月的崩溃总数并记下它们。 有一列用于指定每次崩溃的日期，但不会根据崩溃日期对行进行排序。 我正在考虑使用CTRL + F计算具有特定月/年值的行数，然后记录每次搜索的结果数，但考虑到数据跨越25年，我必须手动搜索并记录300个月的结果。 

I've downloaded a dataset which details all of the car accidents reported in England between January 1979 and December 2004 - this file is in csv format and is understandably quite large (6,224,199 rows, to be exact). Because the size of the file exceeds the number of rows that Excel 2010 can handle, I'd have to split the file into smaller ones in order to open it all at once in Excel. I tried using Notepad and Notepad++, but Notepad crashed, and Notepad++ refused to open such a large (720MB) file. I've considered using an Excel replacement like Delimit, but it doesn't support Macros. Now, overlooking the size issue, I need to count the total number of crashes from each month and make a note of them. There's a column to specify the date of each crash, but the rows aren't sorted according to the crash date. I was considering using CTRL+F to count the number of rows with a specific month/year value and then logging the number of results for each search, but considering that the data spans 25 years, I'd have to manually search and record the results from 300 months.

原文：https://stackoverflow.com/questions/28419493