In Pandas, there is an integer type column, but in one row the value is missing (NULL). What data type will this column have?
Middle
223
Python
10983
584
Have you used MyPy for type checking?
Middle
198
Which is faster: read_sql in Pandas or direct database connection?
Middle
179
Who switches context in an asynchronous approach?
Middle
163
What frameworks did you use for writing Python code?
Middle
162
There are 5 instances of a service with a cron job. How to ensure that the task is executed only once, not five times?
Middle
148
What is the purpose of database normalization? How to determine how normalized the schema should be?
Middle
148
Can you describe the steps of the deployment pipeline? Starting from the code commit — what happens next?
Middle
147
How to validate an incoming CSV/Parquet file in FastAPI (presence of required columns, value ranges)?
Middle
146
How does a Python list differ from a NumPy array?
Middle
141
What is the difference between synchronous and asynchronous inter-service communication? How are they implemented?
Middle
138
Briefly tell about yourself: who are you, what is your experience, why did you come?
Middle
131
There are 5 million rows of data in Pandas — what to do if 100 thousand worked fine, but 5 million did not?
Middle
128
System design: three calculation services, each calls a data service, results need to be saved and quickly displayed in a web interface. How to build such a system with guaranteed calculation execution?
Middle
128
What are indexes used for in relational databases (PostgreSQL)? When do they help, and when do they hinder?
Middle
128
Can a loop be made in an Airflow DAG: task 3 returns to execute task 1 when there is insufficient data?
Middle
128
Why did GetPositive educational company need to write a data bank storage?
Middle
127
How does functional programming differ from object-oriented programming? What approach do you use?
Middle
126
Which package manager do you use?
Middle
122
How to transfer large volumes of data (millions of rows) between tasks in Airflow?
Middle
119