Category : excel

The Data Format is: i want to merge the columns in such a way The data is in loop [‘a’,’a’,’a’,’b’,’b’,’b’,’b’] My output so far is like this: My code snippet is: category=[] for vals in data: category.append(vals[2]) if len(category)>1: for i in range(1,len(list(category))): if category[i] == vals[2]: worksheet.write(row, column, vals[2], cell_text_format) worksheet.write(row + 1, column, ..

Read more

I’ve been trying to set the DTSTART property of iCal to DTSTART;TZID=Europe/Berlin in my python script which is converting events in an excel sheet to iCal events. By default I will get the UTC time with DTSTART:20211019T081500Z. I need to change the timezone and include VTIMEZONE. Does anybody know how to change the iCal properties ..

Read more

I’m trying to work with a bunch of files from a bucket in the Google Cloud Platform. These files are mostly in XLSX format (other files are in xls), so this is the code of how I access them: def read_file(bucket_name, file): if file[-4:] == ‘xlsx’: df_tmp = pd.read_excel(f’gs://{bucket_name}/{file}’, engine=’openpyxl’, header=None) else: df_tmp = pd.read_excel(f’gs://{bucket_name}/{file}’, ..

Read more