So I am trying to parse Facebook ads data using the Facebook Graph API, I was able to create and get all the data I needed, however two of the returned items are lists of dictionaries, specifically the actions field…
As I am very new to R Programming, I need your help to find the answer I have the below data frame as input data, now I want to return the rows which are having the same EntryName but the…
I am trying to add columns to the DataFrame based on the splitting of one column. With two rows, everything works and the empty column takes the value 'None'. The problem when I only have one row and the DataFrame…
Environment: python 3.8.5 ipython 7.20.0 jupyterlab 3.0.7 ubuntu 20.04 LTS pandas 1.2.2 openpyxl 3.0.10 googledrive (spreadsheet) I'm doing... import pandas as pd ef = pd.ExcelFile('myfile.xlsx') df = ef.parse(ef.sheet_names[0], headers=None) display(df) Parsing exported xlsx from google spreadsheet to dataframe. The spreadsheet's…
I'm trying to sort list by frequency and then by name (pandas 1.3.2, python 3.10). Firstly, I count each occurence in list, then, if amount is equal, names must be ordered alphabetically. I found out that all works when len(list)…
I call the oxidation states of A and B in AB compounds from list1 ('CaFe', 'BaSi', 'SeOs', 'BaGeO', 'CdCe'): dfA = pd.read_csv("oxi_state.csv",index_col=0, header =0) A1 = [] A2 = [] final = [] for i in range(len(list1)): A1 = dfA['OS'][list1[i][0]]…
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='',…