notbook | Jupyter Notebooks are flawed and the world | Code Editor library

I'm super new to SQL.

I am writing a fairly simple query and am stuck on something.

The company I work for transfers goods between different sites we keep track of these with two main tables. Table1 is the transfer header, Table2 is the goods that are being transferred. As the goods are being booked on at the receiving end this updates a status field in Table2 and when the whole transfer is booked on this updates the status in the header table.

I'm trying to find the header records for transfers that have not had every product booked on yet but have erroneously updated the header.

I struggling to get the WHERE clause correct, I have tried the following and variants of it with no luck.

i write python project in colab i need to add more than python file in the notbook i cant upload from subfolder in the drive from google.colab import drive drive.mount('/content/drive/MyDrive/')

I have two dataframes df and hash_file like as shown below

I have made the two modules (which are incomplete I guess) for the main function but couldn't make the main function

Create a script file named lottohelper_using_getopt.py for the module in your current workspace/directory.

Define a function named lotto649 (in the script/module file) which can generate and return six different random integers in a list from range [1,49]. (1 point)

Define a function named lottomax (in the script/module file) which can generate and return seven different random integers in a list from range [1,50]. (1 point)

Import the lottohelper_using_getopt module in Jupyter notebook, and call the two functions lotto649 and lottomax, and report your result in a Jupyter notbook cell. (1 point)

You have to use the randrange() or randint() function from the random module https://docs.python.org/3/library/random.html.

Define the main function (in the script/module file) which will allow you to provide options, through the getopt module, (3 point) such as

help information to show how to use it, choosing type between 649 and MAX, using -v or --verbose to control verbosity. You need to use a positional argument to specify how many tickets you want it to generate.

In the main function, once you parsed the parameters, you need to write code to generate multiple tickets. (1 point)

Run the lottohelper_using_getopt.py in command line (or in a Jupyter lab cell using !python lottohelper_using_getopt.py ), e.g. python lottohelper_using_getopt.py -v 1 --type MAX 4 which means you tell your script to generate 4 LottoMax tickets (i.e. four sets of random numbers printed on the screen). Report your result in a notebook Raw cell. (1 point)

This is the output that should come

I am pulling my hair out trying to get jupyter lab to run. I previously had it running great, but the machine which was running my server was reset for the first time in months, and since, I am unable to connect to lab.

Jupyter-notbook is working fine.

I have seen various suggestions online to update this and that, to execute jupyter lab build but nothing has helped. I have even tried a fresh install of miniconda, and creating a fresh environment.

I get this output when I try to connect:

This is a very noob question so please forgive me.

Please can someone help me drill down into a nested dictionary.

I'd like to know how to access the dictionary "data" (see data in link) so that I can then analyze it.

Many thanks in advance.

My sample data is here:

I'm using jupyter notbooks.

This is what I have so far:

I'm trying to get all the Documents saved in a ES Index called: news (44908 Document) and the save them in a DataFrame

but when running the script, I only get the first ten Documents.

This is my Code:

I created a colab notbook and write the following codes in colab:

this is simplified version of a program that I am writing, and as it is, works. I use the last button to test to see my fiction works, and it does.

I need to make the