Remove punctuations in pandas [duplicate]
Using Pandas str.replace and regex: df[“new_column”] = df[‘review’].str.replace(‘[^\w\s]’,”)
python
django.db.utils.IntegrityError: duplicate key value violates unique constraint “django_content_type_pkey”
Although I am not 100% certain this is the problem, there is a good chance your sequence is out of date. Does executing this within Postgres solve the issue? SELECT setval(‘django_content_type_id_seq’, (SELECT MAX(id) FROM django_content_type));
How to find all files with a particular extension? [duplicate]
try changing the inner loop to something like this results += [each for each in os.listdir(folder) if each.endswith(‘.c’)]
Regular expression to match start of filename and filename extension
For a regular expression, you would use: re.match(r’Run.*\.py$’) A quick explanation: . means match any character. * means match any repetition of the previous character (hence .* means any sequence of chars) \ is an escape to escape the explicit dot $ indicates “end of the string”, so we don’t match “Run_foo.py.txt” However, for this … Read more
Remove zero width space unicode character from Python string
You can encode it into ascii and ignore errors: u’\u200cHealth & Fitness’.encode(‘ascii’, ‘ignore’) Output: ‘Health & Fitness’
Pandas: slow date conversion
Note: As @ritchie46’s answer states, this solution may be redundant since pandas version 0.25 per the new argument cache_dates that defaults to True Try using this function for parsing dates: def lookup(date_pd_series, format=None): “”” This is an extremely fast approach to datetime parsing. For large data, the same dates are often repeated. Rather than re-parse … Read more
Django REST Framework: ‘BasePermissionMetaclass’ object is not iterable
You have mistyped the comma in DEFAULT_PERMISSION_CLASSES value, due to which Django takes it as a string, instead of a tuple. Solution: REST_FRAMEWORK = { … ‘DEFAULT_PERMISSION_CLASSES’: ( ‘rest_framework.permissions.IsAdminUser’, ), … }
Is there a more elegant way for unpacking keys and values of a dictionary into two lists, without losing consistence?
keys, values = zip(*d.items())
How to fix ipykernel_launcher.py: error: unrecognized arguments in jupyter?
A more elegant solution would be: args, unknown = parser.parse_known_args() instead of args = parser.parse_args()
numpy convert categorical string arrays to an integer array
np.unique has some optional returns return_inverse gives the integer encoding, which I use very often >>> b, c = np.unique(a, return_inverse=True) >>> b array([‘a’, ‘b’, ‘c’], dtype=”|S1″) >>> c array([0, 1, 2, 0, 1, 2]) >>> c+1 array([1, 2, 3, 1, 2, 3]) it can be used to recreate the original array from uniques >>> … Read more