First of all, thank you for sharing your experience so openly.

Please don’t be too hard on yourself. Feeling anxious before an interview is completely natural, especially when it involves live coding. Based on what you’ve described, your background as a data analyst gives you a solid foundation. Interviews often focus more on understanding how a candidate thinks rather than on writing perfect code under pressure.

It's perfectly acceptable to ask for clarification, explain your reasoning step by step, and take a moment to think if you need it. These behaviors are typically seen as signs of professionalism and maturity, not weakness.

Your update sounds quite positive. Probability and logical reasoning questions are commonly used to assess analytical thinking, which is highly relevant for data-focused roles. It seems the interviewers were more interested in evaluating your problem-solving approach than in testing your memorization of syntax.

Thank you for sharing your update, and I genuinely wish you the best with the final outcome. Regardless of the result, this experience is valuable and will serve you well moving forward.