i need do read the rows of a dataframe but it seems to stop at the first row. I also tried with iterrows but the results are similar. and the outpus is : so the for doesn’t iterate. I hope someone can help me, thank you so much. Answer You are performing inside the loop. This breaks the loop on
Tag: loops
How to compare 2 dictionary values in Python and make pairs with common ones by keys?
I have 2 columns: one is the Pandas DateTime Dataframe (data[“start”]) and the second is the tags, data[“parallels”] for example. So i’m going to create a dictionary, like this: So, the output dictionary is: {3: ‘1.0’, 5: ‘1.0’} How can i check this dictio…
Finding identical numbers in large files python
I have two data files in python, each containing two-column data as below: There are about 10M entries in each file (~400Mb). I have to sort through each file and check if any number in the first column of one file matches any number in the first column in another file. The code I currently have converted the…
How To Recurisve JSON file without any loop (like:for,while,etc) in Python
I’m confuse how to create recursive function to print JSON file without any loops in Python3. So i have home work from my college, the subject is about recursion in function, the lecturer told me to to use recursion only instead of loops. My json file in Category.json is: My python code is: I’m no…
Input variable name as raw string into request in python
I am kind of very new to python. I tried to loop through an URL request via python and I want to change one variable each time it loops. My code looks something like this: I want to have the url change at every loop to like url_part1+code+url_part3 and then url_part1+NEXTcode+url_part3. Sadly my request badly…
How can I use the content of a file as a condition?
I installed AutoKey on my computer so I can execute python files with the keyboard, and what I want to do is execute a script as a loop but also being able to stop it. The script presses the “d” key on my keyboard, waits around 2.4 seconds, and then presses “s”. What I thought would be…
Without iterating row by row through a dataframe, which takes ages, how can I check that a number of rows all meet a condition?
I want to do the following, but obviously I realise that this kind of iterative method is very slow with large DataFrames, what other solutions are there to this problem?: What I would expect the code above to do is: Sub in n from 0 to 1,000 into line 3, with an i of 0, and then if the condition
Find three numbers from a list that add up to a specific number
How can I adjust the below code to find three numbers instead of two numbers yielding the target amount? I’ve already came across the code below from another question titled “Find two numbers from a list that add up to a specific number”. Thank you. Answer If the numbers list is relatively s…
Automatic data wrangling on Pandas with multiple dataframes using lists and loops
for professional purposes I need to produce some reports that includes new entries every week. I have 16 dataframes having same column names (df names are week1, week2… week16). I created a list of the dataframes and then a loop. I wanted to test rename of column with index = 1 and I did not succeed. I …
How to find all columns contains string and put in a new columns?
I was wondering how could I find all values that start with ‘orange’ from all the columns and parse it into new columns. expected output : Answer Let’s try stack then filter by str.contains: df1: Or melt for same order as OP: df1: regex ^orange: ^ asserts position at start of a line orange m…