Below is a summary of interviews for a software company. Mark the entire line that refers to a potential DAX programmer who handled the recruitment task in less than 4h.
Source:
DAX instructor candidate took 3h to complete the task:John K
SQL instructor candidate took 3h to complete the task:Amy B
DAX instructor candidate took 4h to complete the task:Paul K
R instructor candidate took 5h to complete the task:Bob W
Task 3.
Mark in full the sentences that mention R or SQL or Python
Source:
Python is a language that an aspiring analyst should consider learning
Cobol is a language that an aspiring analyst should consider learning
R is a language that an aspiring analyst should consider learning
SQL is a language that an aspiring analyst should consider learning
C# is a language that an aspiring analyst should consider learning
Simply post your code and a screenshot of your results.
import re
#task2
string_task2 = """
DAX instructor candidate took 3h to complete the task:John K
SQL instructor candidate took 3h to complete the task:Amy B
DAX instructor candidate took 4h to complete the task:Paul K
R instructor candidate took 5h to complete the task:Bob W
"""
regExp_task2 = ".*[0-3]h.*:(.*)"
matches_task2 = re.findall(regExp_task2,string_task2,re.MULTILINE)
print("Candidates : ",', '.join(matches_task2))
task 3
import re
#task3
string_task3 = """
Python is a language that an aspiring analyst should consider learning
Cobol is a language that an aspiring analyst should consider learning
R is a language that an aspiring analyst should consider learning
SQL is a language that an aspiring analyst should consider learning
C# is a language that an aspiring analyst should consider learning
"""
regExp_task3 = r".*\bPython\b.*|.*\bSQL\b.*|.*\bR\b.*"
matches_task3 = re.findall(regExp_task3,string_task3,re.MULTILINE | re.IGNORECASE)
print ( "All matches : ",', '.join(matches_task3) )
Thanks All for participation. Below You will find my solutions.
Task 1 Solution
First version.
In this solution, we start with a class of characters that consists of a lowercase or uppercase letter E ([Ee]). It is followed by any character (.) and the information that it can occur an unlimited number of times. The expression ends with the requirement that the text ends with an uppercase letter ([[:upper:]])
In the second solution, we again use the same character class, but require it to be followed at least once (+) by a lowercase letter ([[:lower:]]) and then at least once (+) by an uppercase letter
In this expression, we start by defining the anchor (^), which tells us what the expression must start with. It can be followed repeatedly by any know, a number between 1 and 3, letters of any size ( at least once) and again any character.
In this expression, we start by defining an anchor (^), which tells us what the expression must start with. It can be followed repeatedly by any character, a number from 1 to 3, letters of any size (at least once) and again by any character. We end the expression with information about one occurrence of a special character ([[:punct:]]{1}) and close the whole thing in parentheses to specify this first group. The second group is at least one occurrence of a letter, a space, and a letter again.
In this expression, we define an alternative. The expression consists of the letter R and any characters or the text “SQL” and any characters or the text “Python” and any characters.
Hello @BrianJ , Very good solutions. In the last one you probably identified more potential pitfalls than I did. The simpler solution works well for this task, but if, for example, the names of the languages were repeated at the end, it would be better to have additional tags like yours.
Hi @zwhite , Thank you for submission. Could you please check if solution for task 2 takes only DAX into consideration? In regex101.com I see also SQL marked. But groups are captured well.
