I have a scrapping python project which stored pandas data frame in a csv file. I setup docker run mongo but cant figure out how to store the data of csv file in mongodb. Do I have to copy the…
I have tried to containerize my python code , this is working, building the docker image, running the container and invoking the python code in my app.py file. next, i want to be able to upload the sample.txt file that…
I am trying to figure out how to get value_counts from how many times a specific text value is listed in the column. Example data: d = {'Title': ['Crash Landing on You', 'Memories of the Alhambra', 'The Heirs', 'While You…
I have a requirment where i need to pass different dataframes and print the rows in dataframes to the csv file and the name of the file needs to be the dataframe name. Example Below is the data frame **Dataframe**…
I'm trying to find all combinations of a substring found in a single column, and then explode the dataframe with all possible combinations of each word. Example Dataframe URL Keyword 0 http://www.amazon.com Amazon Lightning Sale 1 https://www.ebay.com Shop eBay Today…
I'm getting data with Facebook Insights API and there are nested columns in the data I get. I tried separating them by index but failed. column I want to split: [{'action_type': 'link_click', 'value': '1'}, {'action_type': 'video_view', 'value': '1'}] the state…
Editing this to reflect addition work: Situation I have 2 pandas dataframes of Twitter search tweets API data in which I have a common data key, author_id. I'm using the join method. Code is: dfTW08 = dfTW07.join(dfTW04uf, on='author_id', how='left', lsuffix='',…
I have a large amount of data in a collection in mongodb which I need to analyze, using pandas and pymongo in jupyter. I am trying to import specific data in a dataframe. Sample data. { "stored": "2022-04-xx", ... ...…
I'm a novice python programmer and I'm trying to use the requests library to find http status codes for a large list of urls, put those status codes into their own array, then add the status code array back to…
I have two data sets, NA and HG len(NA)=267 NA = [73,49,53...] len(HG)=176 (HG is similar list like NA) I want to draw the two data sets into one plot like this (I got this one by drawing them independently…