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='',…
I have two columns with a list of each strings, named Tag 1, Tag 2. In simple terms I need to check if a string in a cell is found anywhere in the adjacent column and if so, swap the…
Dataset Please advice on the best way to read this type of data into a data frame in R. Using read.table("Software.txt") only gives the error: Error in scan(file = file, what = what, sep = sep, quote = quote, dec…