Some sql, py, dax examples for learning, kaggle stuff
For use in pandas use df['variable'] = df['variable'].replace('regex to replace', 'what to replace with', regex=True)
Replace every simbol AFTER / . df['variable'] = df['variable'].replace('/[^/]*$', '', regex=True)