Real questions from top companies in Python/Coding
GeoPandas - definition and features
Given 1TB of a file, how to check word count?
Given a list of integers, write a Python function to return the number of unique pairs that sum up to a target.
Given a list of intervals, merge the overlaps. How do you optimize it?
Given a string 'AAAVGXFHHFSGFGGLK', find the non-repeating letters.
Given an n-ary tree, write code to flatten it and store the output in a list.
Given the Infix, Prefix, or Postfix notation of an expression, write the code to compute the final result.
Given the input string "AAABBBCCCDDDAAA," compress it to output "A3B3C3D3A3."
Grouping and aggregation functions?
How are strings handled in Scala? How are they different from Java strings?
How do you clean missing values in a pandas DataFrame?
How do you install a Python library that is not in the Databricks runtime?
How do you sort a dictionary based on values?
How does your tech stack support scalability and analytics?
How many cities does each department operate in? List the top 3 departments in terms of the most number of cities. In case of a tie, order by dept_id.
How would you configure workload management (WLM) queues for heavy queries?
How would you decide between using DISTKEY and SORTKEY?
How would you handle memory constraints when processing a large dataset in Python?
How would you implement a program to determine the frequency of each letter in a string?
How would you process a 10TB dataset on a single machine in Python?
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.