Hospital | OpenPower working group collects aggregated hospital

I am writing case expression in my SQL Server where I want to add hard coded value in else block.

I want to check in case expression that if the below DHB output are 2.1 and ABC001 then It should display hardcoded value of ABC Hospital.

...

Error-> Class '_InternalLinkedHashMap' has no instance getter 'psubCatName'. Receiver: _LinkedHashMap len:9 Tried calling: psubCatName

This is my TabPage I'm Trying to fetch data inside tab of TabBar using map.

...

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 want to fetch data from API and use the data in tabbar and tabview.

I want to create (Ayurved app), I have a list of subcategory in the api, I followed this documentation, so I need to add api's subcategory to my TabBar. So How can I do that? I don't understand how this will happen. This is my Tab Page.

...

I need to find the minimum values of three columns that are bigger than the values in another column. Say these five individuals entered a hospital in different months of the year, and they suffered several heart attacks before and after hospitalization. I need the first heart attack after hospitalization.

...

(TL;DR at the end)

I am working on merging 2 well sized postgres databases. As there are ID conflicts and many foreign keys I would have enjoyed that UPDATE foo SET bar_id = bar_id + 100000 CASCADE was a thing in SQL so it magically update everything accordingly. Unfortunately, it's not.

So I want to use a LOOP structure (see below) that will simply edit the references everywhere. I want a select query the return all table_name, column_name that references the column I want.

...

I am using Rasa 2.0 to build an FAQ chatbot, wherein I have a large dataset, and specifying entities while defining intents does not seem efficient to me.

I have the intents and examples defined in nlu.yml and would like to extract entities.

Here is an example of what I want to achieve,

User message -> I want a hospital in Delhi. Entity -> Delhi, hospital

Is it possible to do so?

...

I'm a beginner in python so I have this program where it classifies tweets into different categories (sport,sante, culture...) using keywords and I would like to copy-paste every line of the JSON file that belongs to a certain category into a file named text1 and I did the following : but I guess I did it the wrong way since I keep receiving the same error please any suggestion on how to solve this problem!

...

I'm using hospital admissions data, and trying to tie together a table of observations:

dt_taken patient_id observation value 2020-04-13 00:00:00 patient01 "Heart rate" 69 ...

... with a table of admissions:

patient_id admission_id startdate enddate patient01 admission01 2020-04-01 00:04:20 2020-05-01 00:23:59 ...

... such that it returns a list of observations tied to admissions, and rejects all those that were not made during an admission (eroneously recorded, or taken in outpatient visits etc):

dt_taken admission_id observation value 2020-04-13 00:00:00 admission01 "Heart rate" 69 ...

My relatively simplistic approach to-date has been to iterate over each patient, then each patient's admission, then each observation and assign it to that admission, but given I have >36k admissions and >1million observations this is incredibly time-consuming (and my government-issued laptop hates me for it).

Is there a more efficient way that I'm missing, either using {data.table} (I must confess to being an absolute newbie here, preferring to work in {tidyverse}) or even that I can run on the SQL server where the tables are stored to save my aging laptop?

...