inox | Solver for higher-order functional programs

He.llo, folks

I'm studying SQL and as a practical exercise i'm trying to import a .csv file from my country's governemnt database.

Basically it's a file that contains 4 rows: Date, coin name, value, qnty and these rows aren't formatted as I need it to be.

Date is ok, it is YYYY-MM-DD

Coin name is ok too, because its a string

And value (coin value, like 0.1 or 10) is ok too because of its formatted with dots only

The problem comes with qnty. Quantity is how much coins/notes are available for citizens, but it is formatted with dots and commas (this is the real problem I can't figure out)

Take this example:

1995-01-02;Moedas - 1a. Família (inox);0.01;834.342.314,00

1995-01-02;Moedas - 1a. Família (inox);0.05;636.711.876,00

1995-01-02;Moedas - 1a. Família (inox);0.10;583.076.666,00

1995-01-02;Moedas - 1a. Família (inox);0.25;146.883.388,00

1995-01-02;Moedas - 1a. Família (inox);0.50;329.791.540,00

Is there someway to convert qnty (e.g: 329.791.540,00) into float?

Thank you!

----- edit 01:17 GMT
I applied REPLACE as Marco said to the whole table

I'm getting a FileNotFound error in JupyterLab on macOS when I issue a command to read a CSV file.

This was working until yesterday, when I upgraded to Python 3.9. Now it appears that my path has changed, and Jupyter Notebook and JupyterLab can no longer find files (CSVs, in this instance) stored in the same directory as the notebooks are stored.

I've read that I need to list the path, when I run read_csv, but I've done that and essentially get the same error (though with less Traceback).

This screenshot shows my command and the output (I'm in JupyterLab 2.2.6 on macOS Catalina):

I tried listing the path this way:

I want to extract data from 500+ files which look like that:

I would like to apply a Savitzky-Golay filter (prospectr package) to a dataset. However, all the examples available run the filter for only one sample (curve with a determined number of wavelengths). Is there anyway I can filter the data of more samples (70 samples) at once?

Hello I have another problem with split string

First it was when spliting by second upper letter like this (thanks for Omire):

1. I am running the following program to check the availability of given products (A) in a product catalog (B)

2. The program is working fine within small input of given product and catalog like example below with 3 products in given products and 3 products in catalog.

3. The issue is that when the given products and the product catalog become bigger like 50,000 given products and 150,000 products in catalog, it takes a lot of time and effort to run the program. O

4. Every single product in A will loop through entire catalog B to select the maximum match. So the loop will be 50,000 X 150,000.

5. They are all in Excel. Table A has 2 columns (Seller_Name and product_title) with 50000 rows of product. Table B has 2 columns (product_code and product_title) with 150,000 rows

6. I cut the product tile by white-space like example below to run program.

7. Kindly let me know how to tackle this.

Thank you!

Input:

1. The objective is to check the availability of the products in a catalog database.
2. The product title is cut into multiple items by white-space.
3. The process is to loop all items in array a through array b without considering NaN value
4. The score is to count how many time each item available in the catalog out of the total item.

Single Array:

I have this code which proves the termination of a sorting algorithm in Stainless/Leon. Note that the ranking functions or measures employed are not the right ones as this comes from a homework set.

I'm fetching data from the server, getting the issue in parsing, The key is present in response but showing null every time. I checked all keys and everything but still not finding JSON key and showing null object for deal_banner. I made response class so many timesin order to get correct parsing and checked every individual key but still not getting correct objects.

This is my response