Leetcode MEDIUM 3204 - Bitwise User Permissions Analysis - Explained by Everyday Data Science

Опубликовано: 05 Ноябрь 2024
на канале: Everyday Data Science

167

Question: https://leetcode.com/problems/bitwise...

SQL Schema:
Create table if not exists user_permissions(user_id int, permissions int)
Truncate table user_permissions
insert into user_permissions (user_id, permissions) values ('1', '5')
insert into user_permissions (user_id, permissions) values ('2', '12')
insert into user_permissions (user_id, permissions) values ('3', '7')
insert into user_permissions (user_id, permissions) values ('4', '3')

Pandas Schema:
data = [[1, 5], [2, 12], [3, 7], [4, 3]]
user_permissions = pd.DataFrame({
'user_id': pd.Series(dtype='int'),
'permissions': pd.Series(dtype='int')
})

#leetcodesolutions #datascience #sql