abuse | Abuse SDL port originally from Crack-Dot-Com | Game Engine library

Problem

I have a large JSON file (~700.000 lines, 1.2GB filesize) containing twitter data that I need to preprocess for data and network analysis. During the data collection an error happend: Instead of using " as a seperator ' was used. As this does not conform with the JSON standard, the file can not be processed by R or Python.

Information about the dataset: Every about 500 lines start with meta info + meta information for the users, etc. then there are the tweets in json (order of fields not stable) starting with a space, one tweet per line.

This is what I tried so far:

1. A simple data.replace('\'', '\"') is not possible, as the "text" fields contain tweets which may contain ' or " themselves.
2. Using regex, I was able to catch some of the instances, but it does not catch everything: re.compile(r'"[^"]*"(*SKIP)(*FAIL)|\'')
3. Using literal.eval(data) from the ast package also throws an error.

As the order of the fields and the legth for each field is not stable I am stuck on how to reformat that file in order to conform to JSON.

Normal sample line of the data (for this options one and two would work, but note that the tweets are also in non-english languages, which use " or ' in their tweets):

I am trying to strip text from my dataframe. Currently I have the following:

Lets say I have multiple variables that measure substance abuse i.e a1 is on alcohal usage, a2 is on bhang and a3 is on cocaine. I would like to generate variable afin that indicates engaged in substance abuse if any of the the three is yes.

Is there a way to shorten the code so I don't specify use multiple ifelse statements as below? Trying to find the best way to do it because I have more than 10 variables to collapse into one and writing ifelse may not be ideal.

I have a game uses Firestore, When the player complete the certain level the game will give him 50 points and will be save the data in Firestore.

Let's suppose someone did reverse engineering for my game and made change from 50 points to 1000 points in code and he rebuild the APK and play my game with the same Firestore database, Now when the player complete certain level the game will give him 1000 points and will be save the data in Firestore and that considered hacked data.

I don't care if someone did reverse engineering of my game and republish it as new game with his own Firestore, But I care about hackers who changed the data on my Firestore

How can I secure my game from fraud and abuse.

I am trying to split multiple columns based on a delimiter and then unpivot those columns.

df:

I have a feeling I'm being very silly, but go easy on me as I'm very new to PHP.

So as part of an application, I'm building, I allow users to generate a URL that can be used to access some of their data from outside the platform. The URL is constructed by the PHP script based on URL parameters in the users browser (fear not, the parameters only allow the passing of integers to prevent abuse).

So to create the URL that will be shared, the script does this:

Is there any known danger with exposing the use of a FullText index to internal and possibly public users?

Assuming the queries are properly parameterized, is there any way that a user could abuse the inputs to trigger a SQL injection or denial of service attack?

Let's say I have:

There's an issue with discord.py.