Import data to read quantities per dimension instead of actual data
Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location. Because the csv file has over 15000 rows, I am not quite sure how I should import the file to obtain my target module. To start off, I want to have a module that just shows how many machines there are per location. So it would just be how many rows read back each location. Really stuck and now sure how to start. Thank you.