Advertisements I have a dataframe, with data in each row as such. MKEYGEDLK How can I process the sequence strings in each row, such that the format will be as such? [M, K, E, Y, G, E, D, L, K] I tried get_seq_str = ‘,’.join(test_df.loc[0][‘seq_1’]) arr.append(get_seq_str) However, when I append it to the dataframe, there… Read More Process string in Pandas Dataframe rows to comma-delimitered chars
Advertisements I have a pandas column that looks like this: 0 LOT 8 BLK 32 MISSIONARY HEIGHTS 1 LTS 31-39 & PT 30, 15-22 LEWIS 2 LT 2 DEPOT SUB …. I want to extract out the lot number from this but sometimes they are spelled "LOT", "LTS" or "LT". And I want to extract… Read More Pandas find matching sub-strings and split on them
Advertisements I have been working on a Python scraper for a while. I want to save the information I get in different files. URLs must be in one file and captions must be in another file. While working with URLs there is no issue, but when I try to scrape the names of the blog… Read More Web Scraper sectioned in different files
Advertisements I want to calculate the average value of every three lines of data in the text. The error is as follows： Traceback (most recent call last): File "/home/code/test1.py", line 7, in <module> lines = sum(lines[i:i+3])/3 TypeError: ‘float’ object is not subscriptable with open(‘/home/data/NB_accuracy_score.txt’, ‘r’) as f: lines = f.readlines() lines = [line.strip().split(‘\t’) for line… Read More TypeError: 'float' object is not subscriptable–
Advertisements TypeScript is complaining TS2322: Type ‘{ clientSecret: string; loader: string; }’ is not assignable to type ‘StripeElementsOptions’. Types of property ‘loader’ are incompatible. Type ‘string’ is not assignable to type ‘"always" | "auto" | "never"’. Where the object is defined as const options = { clientSecret: paymentIntent.clientSecret, loader: "always", } The error… Read More TS2322: Type 'string' is not assignable to type '"union" | "of" | "strings"'
Advertisements I am working on a program that will scrape metacritic for info on the movie from my library and display it but in certain parts like grabbing the rating always returns nothing what am I doing wrong? from bs4 import BeautifulSoup import requests import os def ratingsGet(headers, movie): movie = movie.lower().replace(" ","-") detail_link="https://www.metacritic.com/movie/" +… Read More Python BeautifulSoup failure to get data from a div with a certain class
Advertisements I’m trying to append cell value using openpyxl, by appending the value directly. this works: wb1=load_workbook(‘test.xlsx’) ws1=wb1.active testlist=(‘two’,’three’,’four’,’five’) for i in testlist: ws1[‘A1’].value = ws1[‘A1’].value +(‘ ‘) + i print(ws1[‘A1’].value) A1 has a value of "one", after the loop runs it has "one two three four five" But is it possible to use the… Read More How to append cell values in openpyxl directly
Advertisements Iam exctracting real estate data via scraping in python. I want this data to be in csv file. When i write data to csv if first scraped item dont have value i need, it just skip all the row (but other items have that values), which is null and not creating any row, not… Read More Writing text to csv after web-scraping with python
Advertisements How do you put the rows with the same order_id such that all their corresponding rows add up to form the resulting Dataframe? (in this case quantity & item price should be added with the corresponding order_id before it, and the choice_description & item_name should be added in their "str" format as well) Reproducible… Read More Grouping Rows with same ID together in Python
Advertisements Here I am trying to get the data from the firebase and then use that id to retrieve items from stripe checkout. But each time I try this I get a pending promise. const colRef = collection(db, `users/${session.user.email}/orders`); const q = query(colRef, orderBy("timestamp", "desc")); const orders = await getDocs(q) .then((snapshot) => { snapshot.docs.forEach((sdoc) =>… Read More A pending promise is returned from stripe.checkout.sessions.listLineItems each time