The Accountant - Google Top Interview Questions
Problem Statement :
Spreadsheets often use this alphabetical encoding for its columns: "A", "B", "C", ..., "AA", "AB", "AC", ..., "ZZ", "AAA", "AAB", "AAC", .... Given a column number n, return its alphabetical column id. For example, given 1, return "A". Given 27, return "AA". Constraints 1 ≤ n < 2 ** 31 Example 1 Input n = 1 Output "A" Example 2 Input n = 2 Output "B" Example 3 Input n = 26 Output "Z" Example 4 Input n = 27 Output "AA"
Solution :
Solution in C++ :
string solve(int n) {
string result;
while (n > 0) {
// Since in code 'A' + 25 = 'Z'
n--;
// Get the remainder to identify
// the current character to be
// added to the column number
int curr = n % 26;
// Divide by 26 to process the
// next character
n = n / 26;
// Update the result with the
// current character
result.push_back(curr + 'A');
}
// Since we are adding the most
// significant character to the end
// of the string, reverse it before
// returning
reverse(result.begin(), result.end());
return result;
}
Solution in Java :
import java.util.*;
class Solution {
public String solve(int A) {
String s = "";
int counter = 0;
while (A > 0) {
counter = (A - 1) % 26;
char a = (char) ('A' + counter);
s = a + s;
A = (A - 1) / 26;
}
return s;
}
}
Solution in Python :
class Solution:
def solve(self, n):
ans = ""
# because we have 1 based indexing
# we need to scale 1-27 to 0-26 each time
# so, we use n-1
while n >= 1:
ans += chr((n - 1) % 26 + ord("A"))
n = (n - 1) // 26
return ans[::-1]
View More Similar Problems
Castle on the Grid
You are given a square grid with some cells open (.) and some blocked (X). Your playing piece can move along any row or column until it reaches the edge of the grid or a blocked cell. Given a grid, a start and a goal, determine the minmum number of moves to get to the goal. Function Description Complete the minimumMoves function in the editor. minimumMoves has the following parameter(s):
View Solution →Down to Zero II
You are given Q queries. Each query consists of a single number N. You can perform any of the 2 operations N on in each move: 1: If we take 2 integers a and b where , N = a * b , then we can change N = max( a, b ) 2: Decrease the value of N by 1. Determine the minimum number of moves required to reduce the value of N to 0. Input Format The first line contains the integer Q.
View Solution →Truck Tour
Suppose there is a circle. There are N petrol pumps on that circle. Petrol pumps are numbered 0 to (N-1) (both inclusive). You have two pieces of information corresponding to each of the petrol pump: (1) the amount of petrol that particular petrol pump will give, and (2) the distance from that petrol pump to the next petrol pump. Initially, you have a tank of infinite capacity carrying no petr
View Solution →Queries with Fixed Length
Consider an -integer sequence, . We perform a query on by using an integer, , to calculate the result of the following expression: In other words, if we let , then you need to calculate . Given and queries, return a list of answers to each query. Example The first query uses all of the subarrays of length : . The maxima of the subarrays are . The minimum of these is . The secon
View Solution →QHEAP1
This question is designed to help you get a better understanding of basic heap operations. You will be given queries of types: " 1 v " - Add an element to the heap. " 2 v " - Delete the element from the heap. "3" - Print the minimum of all the elements in the heap. NOTE: It is guaranteed that the element to be deleted will be there in the heap. Also, at any instant, only distinct element
View Solution →Jesse and Cookies
Jesse loves cookies. He wants the sweetness of all his cookies to be greater than value K. To do this, Jesse repeatedly mixes two cookies with the least sweetness. He creates a special combined cookie with: sweetness Least sweet cookie 2nd least sweet cookie). He repeats this procedure until all the cookies in his collection have a sweetness > = K. You are given Jesse's cookies. Print t
View Solution →