All Questions
5,795
questions
-1
votes
0
answers
15
views
Why data that are being written to excel are not starting from the 'A' column?
I'm using pandas to copy data from one excel to another and the data are being copied just not at the right place.
I have this function that reads the data:
def updated_file(self, progress_bar):
...
0
votes
0
answers
24
views
Pandas.ExcelFile Include first header row but only searching on second header row
ugds = set()
for sheet_name in excel_data.sheet_names:
df = pd.read_excel(excel_data, sheet_name=sheet_name, header=1)
ugds.update(df["Pool\n Gestão"].unique())
for UGD in ugds:
...
0
votes
1
answer
59
views
How do I handle merged cells in Excel using Pandas parse function?
I have an Excel file with merged columns and rows, and I want to read the excel file and parse it to convert it into a DataFrame.
This is just a small example of what happened because the real data ...
0
votes
1
answer
36
views
Update data in json kept in excel sheet with python
I have an Excel sheet that has json stored in on of it's cells. Sheet has multiple rows, but every json is in one column.
I need a way to replace some of the elements of that json, and save it back as ...
-2
votes
0
answers
38
views
read_excel returns a dataframe with only 1 filled column and everything else empty, when it's not [closed]
I am using python pandas to extract information from 3 different data sheets in excel. Read_excel works for the other 2 dataframes, but for the last one it returns only 1 column, everything else empty....
0
votes
1
answer
90
views
Is there a way to choose which cell/column of a CSV to upload a dataframe into, just like scraping data onto an excel file?
I have had experience with webscraping data onto excel files, and I know that when copying data down into an excel spreadsheet, you can choose which column to copy it into. (startcol = 10 as shown in ...
0
votes
1
answer
37
views
How to put sum of dataframe column in certain cell of excel sheet?
I have multiple dataframes and for each of them I am creating a separate excel sheet. After I've done this, I want to add for each sheet the sum of a certain column.
I have tried to create a ...
0
votes
0
answers
45
views
Adding a DatePicker into Excel cells using Python XlsxWriter?
I am trying to create an input form using Excel generated by Python XlsxWriter. I wonder is it possible to add a mini calendar (as a DatePicker) into Excel cells for users to input dates?
I stumbled ...
0
votes
2
answers
57
views
Pandas dataframe group by column get count of two columns
I am pulling in data from an excel spreadsheet and creating a list of dictionary objects from the rows in that spreadsheet. I converted that to a pandas dataframe. In this data frame I have a column ...
0
votes
0
answers
62
views
Python Pandas reads inconsistent date formats from Excel files generated automatically with a 3rd part API
I'm using the PDF4me API to convert PDF invoices into Excel files. The dates are read correctly by the API. However, when I open the Excel files, the dates are displayed inconsistently:
Some dates ...
-3
votes
0
answers
38
views
how to filter multiple sheets in an excel file based on a value using python
My issue is simple,
I have an excel file containing multiple sheets, in every sheet there is a dataframe the dataframes on the different sheets have different columns but they all have one common ...
-1
votes
1
answer
72
views
Scrape images into an excel file - Selenium/Pandas/Python [closed]
I'm looking to scrape an image from a website into an excel file.
Below is a snippet of my code. This gets the SRC URL and put that into the excel sheet. Is it possible to turn that into the actual ...
0
votes
1
answer
21
views
Columns of Data missing on Google Sheet file after upload
I have this program that is supposed to take some csv files using pandas and convert them to google sheet files and upload them to my Google Drive folder. However, when uploaded, only the last 8 ...
0
votes
1
answer
43
views
Applying styles to Pandas multiindex, using all index levels for context
I am attempting to style a dataframe with cell colors based on categories provided via the index. Index levels 0 and 1 provide the fruit and part. I want every cell to be colored based on distinct ...
-2
votes
0
answers
64
views
Using Pandas or Openpyxl to put data from a table into a variable
Im looking to be able to put the data from an excel file into one variable
The excel file wont always have the same amount of rows of data, but the columns will stay the same
This is what i believe ...