Closed achoudh5 closed 3 years ago
Hey, I have experience in working with python and its modules. Can you assign this issue to me?
sure @aparharsh
Can we connect on some platform? For eg., on Gmail? So that I can get some more details about the task. I was not able to get your email id on your profile, so can you either give me your mail id or mail on mine?
I would prefer to use this issue thread @aparharsh if that's fine by you. I would be happy to answer any doubts you might have for the issue. Another reason being your doubt might help other people as well :)
I have a few doubts. Will i be given the column names which must be iterated? Or, there will be always two columns, A and C. Only those rows must be considered for the further code whose columns A and C both, must be containing a string of format 1.2.3.4 ? Which cell values must be read, if both A and C contains the format 1.2.3.4 ?
Good Question @aparharsh !
You will always have column name but if you can do without using them it would be superb 💯
Yes, you will iterate over columns A and C. If the format is like an IP address ex. 1.2.3.4 only then read it (you can use regex) else don't read that value and move to next value. Note: 1.2.3.4 is just an example format, ip address values are not hard coded. It should be an ip address, that's important
I wrote the code, along with proper comments explaining the whole code. Can you review it ?
Update:- I have added a sample excel sheet with Column A,B,C Update2:- I also uploaded an Expected Output file, you can color the values you read (color is not important) but column B should be as is. Task:- Ex. Iterate over Column A and C from row-> 1 to 100 & skip column B. Entries in rows would be like 4.4.4.4 or a text like abcd, the cell value should only be read when it's 4.4.4.4 and pass when it's a text The location and name of file should be same Use language: python and module: openpyxl Take an example excel sheet yourself if you want to.
Documentation:-
Please update Readme giving some pointers as well, that'll help understand people who are new to pandas or openpyxl. Thanks and really appreciate your valuable time!
Assigning More Issue (Coming Soon, Comment if interested):-
People who comment first will be given priority, having said said that if you are interested in this manipulation of excel sheet, do comment and I'll create a new exciting issue . I have started with one and after some progress, I'll add more as well. Few examples of upcoming issues:-
Linking the cells in different columns
Replacing the known port numbers automatically with an app-id (checkout https://applipedia.paloaltonetworks.com/ ), few examples of know app-ids would be ssl, web-browsing etc. There is a new column say D with tcp ports, your task would be to replace the port with the associated app-id in for that cell value
and more.....it never ends 🗡️