Vote | Simple Vote by SMS Application | SMS library

So I created a poll model in my Django app. I'm going thorugh the polling app tutorial posted on the Django website, however, I'm using a remote MySQL database rather than a SQLite database.

dispatcher-servlet.xml

I want to keep track a vote on each time it's submitted. All corresponding data in the submittedVoteId is what I want to use to count the vote for the aspirants

Here are the data I got when voters submitted their votes

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):

According to Wikipedia, the ASCII is a 7-bit encoding. Since each address (then and now) stores 8 bits, the extraneous 8th bit can bit used as a parity bit.

The committee voted to use a seven-bit code to minimize costs associated with data transmission. Since perforated tape at the time could record eight bits in one position, it also allowed for a parity bit for error checking if desired.[3]:217, 236 §5 Eight-bit machines (with octets as the native data type) that did not use parity checking typically set the eighth bit to 0.

Nothing seems to mandate that the 8th bit in a byte storing an ASCII character has to be 0. Therefore, when decoding ASCII characters, do we have to account for the possibility that the 8th bit may be set to 1? Python doesn't seem to take this into account — should it? Or are we guaranteed that the parity bit is always 0 (by some official standard)?

If the parity bit is 0 (default), then Python can decode a character ('@'):

I need to do a formula in excel that does average to column of votes if it matches to the season in that row, former, and next season (except from the first and last season). For example, if I am in a row on season 3, I need to do average of all the votes in seasons 2,3 and 4. Right now I tried : =AVERAGEIFS(I$2:I$237,B$2:B$237,$B2,B$2:B$237,IF($B2=1,$B2,$B2+1),B$2:B$237,IF($B2=10,$B2,$B2-1))

(I- is the column of votes, B - is the column of seasons) But it returns error: #div/0!

This is a small example of the table.

I would like for help to solve this problem.

My dataframe df is:

I make some listview and it have likes and comments section. I want to show how many likes and comments that post had. The like section works by displaying the number of users who like it, i try to show it with snapshot.data.docs.length.toString() from firestore but when i try to show how many comments with same code as like section it not working and only get 0.

this is inside comments field

My dataframe df is: