I have an xlsx file containing too much data. however the data contains duplicate values in column named UniversalIDS which I wanted to replace it with a randomly generated IDS with Pandas. So far I’ve tried different scenarios which I googled but did not work. for example I tried this: also I tried oth…
Tag: excel
Extracting all data validation formula values(dropdown) from excel sheet
How can we extract the data validation dropdown values(not just formulas/references or a single valued formula result) from a given excel sheet using python? Currently openpyxl helps us to get the formulas but not the values directly. It even fails in cases where file contain extensions(extLst) to the OOXML s…
How to normalise a date columnin pandas dataframe to the same format
I have a dataframe made from pulling in different excel sheets. I am trying to normalise the date_time column to just a standard DD/MM/YYY format. Is that possible? 1 DATE Column 3 Column 4 Column 5 Column 6 2 01/03/2021 00:00 3 01/03/2021 00:00 4 01/03/2021 00:00 5 01/03/2021 00:00 6 01/03/2021 00:00 ……
How can I use Python to convert multiple columns in the same row to another row?
I have an excel file which has multiple title names as columns within the same row where the data is given, I need to sort the data and convert the column names to rows and assign it to the data under the “column names” enter image description here My expected output is for it to turn out like thi…
Name ‘ ‘ is not defined – python
from bunch of files I want to extract some info (code is below), but I came across error: “name ‘GH_Pos21X_true’ is not defined”, full error: Where should I defined it? Code: I can’t see a problem, maybe someone could help me find my mistake? I will be grateful. If I don’t …
How to return list of all values that have matching first 4 characters
I have a large list of product ID’s setup up in the following format; The first 4 numbers representing the style of product and corresponding 3 letters representing the colour, as a result any products that have the same 4 number style ID will be identical products (just different colours) I would like …
How to append dataframe to an existing excel file with some rows of data in it?
I have an excel sheet which has 150 rows of data. Now, I want to append a dataframe to that sheet without deleting or replacing the data using python. I have tried code like this, it is deleting the existing content from the excel and writing the dataframe into it. And other solutions provided here but with n…
Converting Excel to PDF with pywin32 [Error]
I try to export one of my xlsx files as PDF with pywin32: Unfortunately I get this com_error: In the end I want to do use this conversion on 30 xlsx files at once. I know how to write the loop for this but can not fix the above mentioned error. Answer When using Python paths on Windows, you need
Pandas Set Index Based On Column Value
I’m new to pandas, I have a Dataframe read from excel file, like this screenshot below where Products is the header and Google and Meta is the group (index) Using pandas I would like the dataframe to be like this Thank You Answer Using pd.assign and np.where
Want to extract contact URL link for the every single person from a web page using python in CSV file
I want to extract Name, Position and Email from the webpage for every person, I did extract the name and position but as the email is not possible to extract since you have to contact them to know. I just want to extract their contact URL. Every person has different contact URL I want to extract in a way that