Nov-08-2023, 02:41 PM
So im not looking for functional code, i want to keep learning and just need suggestions or pointers on what to look at in order to accomplish the following:
I have a CSV file with (IP, Store, Register, Status) this is provided from one system. Then in a totally different system we have support tickets, which we can get an export out of in CSV as well. It will contain (Store, Problem Description, Problem #, Date Opened)
The common link between the 2 csv files is the store #, so i would like to be able to write some logic to consume both files, and "search/return" all records from csv file #2 that exist in csv #1 by store and have a new dataframe returned with just those results.
Simple Example
CSV #1 (Store 5 was reported as "Down" when the ping script ran)
111.22.33.4 , 4, 200, 0
111.22.34.5 , 5, 201, 1
111.22.35.6 , 6, 202, 0
111.22.35.7 , 6, 203, 0
CSV #2 (Service report shows that there is currently a ticket/problem opened for Store 6)
6,"Register 202 down", 29743, 11/7/2023
6,"Register 203 down", 29745, 11/7/2023
Return a dataframe that returns a total count of records found by store
Expected Dataframe Data: (Store, Ticket Count, [Ticket #])
If possible in the dataframe, if not in whatever can return the data in this structure
4,0,0
5,0,0
6,2,[29743,29745]
If this is possible, what should i look at using? Pandas Dataframes, Series, Numpy, etc....)
Looking for suggestions on being able to accomplish this efficiently
I have a CSV file with (IP, Store, Register, Status) this is provided from one system. Then in a totally different system we have support tickets, which we can get an export out of in CSV as well. It will contain (Store, Problem Description, Problem #, Date Opened)
The common link between the 2 csv files is the store #, so i would like to be able to write some logic to consume both files, and "search/return" all records from csv file #2 that exist in csv #1 by store and have a new dataframe returned with just those results.
Simple Example
CSV #1 (Store 5 was reported as "Down" when the ping script ran)
111.22.33.4 , 4, 200, 0
111.22.34.5 , 5, 201, 1
111.22.35.6 , 6, 202, 0
111.22.35.7 , 6, 203, 0
CSV #2 (Service report shows that there is currently a ticket/problem opened for Store 6)
6,"Register 202 down", 29743, 11/7/2023
6,"Register 203 down", 29745, 11/7/2023
Return a dataframe that returns a total count of records found by store
Expected Dataframe Data: (Store, Ticket Count, [Ticket #])
If possible in the dataframe, if not in whatever can return the data in this structure
4,0,0
5,0,0
6,2,[29743,29745]
If this is possible, what should i look at using? Pandas Dataframes, Series, Numpy, etc....)
Looking for suggestions on being able to accomplish this efficiently