Trending questions in Edureka Community

0 votes
3 answers

How to replace negative numbers in Pandas Data Frame by zero?

 If all your columns are numeric, you ...READ MORE

Dec 16, 2020 in Python by Rajiv
• 8,870 points
45,353 views
0 votes
1 answer

Apache POI Excel row color is only black and doesn't change

Use this: style.setFillPattern(CellStyle.SOLID_FOREGROUND); In combination with: style.setFillForegroundColor(IndexedColors.AQUA.getIndex()); Sets the background color ...READ MORE

Jan 6, 2023 in Others by narikkadan
• 63,600 points
1,636 views
0 votes
1 answer

How do I show the computations after S/N 1048576 in a separate sheet

Add: If xRg.Row = xRg.Parent.Rows.Count Then ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,600 points
549 views
0 votes
1 answer

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

You can use OLEDB to create and ...READ MORE

Jan 3, 2023 in Others by narikkadan
• 63,600 points
1,758 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,600 points
763 views
0 votes
1 answer

How can I perform a reverse string search in Excel without using VBA?

This one is tested and does work ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 63,600 points
1,667 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

In the stacktrace, there is a line ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
6,438 views
0 votes
1 answer

When a row is added to one sheet, automatically add a row to another sheet

Use the VLOOKUP function. Your Spreadsheet 2's first column will ...READ MORE

Dec 10, 2022 in Others by narikkadan
• 63,600 points
3,018 views
0 votes
0 answers

Java snapstart is not available in AWS Lambda

I have started to write Java Lambdas ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 3,820 points
899 views
0 votes
0 answers

How to solve IndentationError

 for intent in intents['intents']:         ...READ MORE

Feb 11, 2023 in Python by anonymous

edited Mar 4 59 views
0 votes
0 answers

Azure pipeline dynamic creation of variables based on parameters

I've included an azure-pipeline.yml file that references ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,750 views
0 votes
1 answer

Pivoting 4x4 into 16x1

Try this: df <- tibble::tribble( ~ID, ~sit1, ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,600 points
565 views
0 votes
1 answer

Extracting info from hyperlink

This will offer you an example of ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,600 points
426 views
0 votes
1 answer

Unable to download excel file from src/assets in development/qa/prod environment for angular application

Try this: this.HttpClient.get("./assets/sample.xlsx",{responseType: "blob"}).subscribe((res:any) => ...READ MORE

Nov 12, 2022 in Others by narikkadan
• 63,600 points
3,970 views
0 votes
0 answers

java.lang.NoClassDefFoundError: org/openqa/selenium/WebDriver

I added all the selenium  jars in ...READ MORE

Feb 10, 2023 in Selenium by anonymous

edited Mar 4 81 views
0 votes
1 answer

Iterate thru specific controls in a form using a loop

The textbox numbers you want to iterate ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,600 points
588 views
0 votes
0 answers

How to list projects inside the folders in folders in GCP

How can we list the GCP projects ...READ MORE

Feb 10, 2023 in GCP by MGX

edited Mar 4 76 views
0 votes
1 answer

Public variable for captura path in vba excel

An assignment statement (as ruta = ActiveWorkbook) ...READ MORE

Jan 22, 2023 in Others by narikkadan
• 63,600 points
883 views
0 votes
1 answer

Modifying CSV files from a local folder-VBA

Solution  You need to fully qualify your Columns object ...READ MORE

Jan 17, 2023 in Others by narikkadan
• 63,600 points
1,099 views
0 votes
0 answers

Deployment dependencies condition skipped azure pipeline.

I built a pipeline. There are two ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,637 views
0 votes
0 answers

what machine learning model is used in chatgpt application?

It's just out of curiosity but which ...READ MORE

Feb 10, 2023 in ChatGPT by erzan
• 630 points

edited Mar 4 65 views
0 votes
1 answer

How to link two excel sheet in same excel file

It would be best if you made ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,600 points
574 views
0 votes
0 answers

Not all parameters are used

def update_data(self):         if self.var_dep.get()=='Select Department' or self.var_std_name.get()=='' or ...READ MORE

Feb 10, 2023 in Python by Aryazayo

edited Mar 4 70 views
0 votes
1 answer

Is there any way to change input type="date" format?

To answer your question, it is impossible ...READ MORE

Feb 18, 2022 in Others by Aditya
• 7,680 points
15,452 views
0 votes
1 answer

Want to create a chronological row # then reset based on font color

Use this function to test the font ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,600 points
394 views
0 votes
1 answer

Formula to remove every middle name in a cell in Excel

Use this: =IFERROR(LEFT(A1,FIND(" ",A1)-1),A1) What does it do? Finds the ...READ MORE

Jan 19, 2023 in Others by narikkadan
• 63,600 points
998 views
0 votes
0 answers

I am trying to configure and install puppet on a slave node but to no avail. The error message is shown below.

+ sudo dpkg -i puppetlabs-release-pc1-xenial.deb sudo: no tty ...READ MORE

Feb 9, 2023 in Puppet by Ferdinand

edited Mar 4 123 views
0 votes
1 answer

How to print the next row every time a function runs? (openpyxl)

Verify the indentation. I executed the sample ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 63,600 points
1,518 views
0 votes
1 answer

My VBA macro slows down dramatically with each use

You have a function called ExportRange that ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 63,600 points
911 views
0 votes
1 answer

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

 The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,600 points
560 views
0 votes
0 answers

Adding Pyjwt to aws lambda function layer

I'm attempting to add the Pyjwt library ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 3,820 points
1,705 views
0 votes
1 answer

Jquery math sum method

“sum of two numbers in jquery” Code ...READ MORE

Aug 5, 2022 in Web Development by rajatha
• 7,680 points
8,177 views
0 votes
1 answer

Use python extract images from Excel sheets

I found a solution # installing the modules pip3 ...READ MORE

Apr 11, 2022 in Database by gaurav
• 23,260 points
13,299 views
0 votes
0 answers

How to consolidate multiple tables in one table using power bi ?

Hi, I have pdf wanted to upload in ...READ MORE

Feb 10, 2023 in Power BI by Amit

edited Mar 4 38 views
0 votes
0 answers

How can I use the Azure DevOps Pipeline with a specific older version of Ruby?

For a project I'm working on, Ruby ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
• 1,230 points

edited Mar 4 170 views
0 votes
0 answers

Are there any services like Databricks but without compulsion of AWS/Azure/Google Cloud?

I'm doing a course on Udemy for ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 3,820 points
780 views
0 votes
0 answers

May I know who is my trainer for the upcoming batch?

Request you to let me know who ...READ MORE

Feb 9, 2023 in Others by Priyanka

edited Mar 4 58 views
0 votes
0 answers

Get the query string value and display it in my html page

I can see the query string values ...READ MORE

Jul 21, 2022 in HTML by Ashwini
• 5,430 points
1,921 views
0 votes
1 answer

How to do multiple transpose in excel vba

Use Dictionary object Sub test2() With New ...READ MORE

Jan 22, 2023 in Others by narikkadan
• 63,600 points
830 views
0 votes
0 answers

Passing azure secret variables to pytest in pipeline?

We are using Azure Pipeline to run Python integration tests.  These tests make use of a database, and the login information is saved in an Azure variable group that also contains secret variables.  The integration tests are started in this section of the yaml file: jobs: - job: IntegrationTests variables: ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
• 1,230 points

edited Mar 4 148 views
0 votes
0 answers

Is there a way to import multiple repos at once from github into azure devops?

I would like to transfer a github&nbs ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
• 1,230 points

edited Mar 4 137 views
0 votes
1 answer

Conditional Formating in Excel comparing dates between cells

To get a date from your strings, ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,600 points
640 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 63,600 points
725 views
0 votes
0 answers

import .cert file to azure keyvault issues

I added a.cert certificate to Azure DevOps ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
• 1,230 points

edited Mar 4 133 views
0 votes
1 answer

VBA How To Paste With Blank One Column Over?

Try this: Option Explicit Sub CopyPaste() ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,600 points
635 views
0 votes
0 answers

How to delete unwanted artifacts in Azure DevOps

Numerous NuGet packages are created by our ...READ MORE

Dec 13, 2022 in DevOps on Cloud by Edureka
• 13,650 points
2,552 views
0 votes
1 answer

Get inserted image to adjust the row height in Excel

Try this: 'just find Photo1 cell and select ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 63,600 points
719 views
0 votes
1 answer

Can not get bubble sort to run in excel's developer mode

Bubble Sort a Single-Column Range A Quick Fix Option ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,600 points
460 views
0 votes
1 answer

How do I find top row visible on Sheet in Excel

Try this: ? Activewindow.VisibleRange.Row READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,600 points
500 views
0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 63,600 points
843 views