Amara Nwosu
@amaran
Member · Member since Oct 2017
Data engineer: Spark, pandas, and too much SQL.
0 followers · 0 following
Badges and trust level are earned across the whole community.
- Topics created
- 4
- Posts created
- 3
- Likes given
- 25
- Likes received
- 31
- Days visited
- 0
- Solutions
- 1
Days visited count across the whole community, not just this forum.
Most active topics
- How do I select rows from a pandas DataFrame based on column values?
5 replies · 13 votes
- React: useEffect runs twice in development
2 replies · 6 votes
- Spark: how to avoid a shuffle when joining a small table?
1 replies · 2 votes
- Regex to match a hex colour like #fff or #1a2b3c
1 replies · 0 votes
Most liked posts
- How do I select rows from a pandas DataFrame based on column values?
I have a DataFrame of orders and want only the rows where status is "shipped" and total is above 100. In SQL: SELECT * FROM orders WHERE status = 'shipped' AND
13 likes
- Async Python: run blocking code without freezing the event loop
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
10 likes
- React: useEffect runs twice in development
My useEffect with an empty dependency array fires twice on mount, so my analytics event is sent twice. Is my component mounting twice?
6 likes
- Spark: how to avoid a shuffle when joining a small table?
Joining a 2 GB fact table with a 5 MB lookup table causes a full shuffle. Any way to avoid it?
2 likes
Top categories
Top tags
- #apache-spark 1
- #dataframe 1
- #javascript 1
- #pandas 1
- #performance 1
Recent badges
- Spark: how to avoid a shuffle when joining a small table?
Liked by Dmitri Vasko
Joining a 2 GB fact table with a 5 MB lookup table causes a full shuffle. Any way to avoid it?
Likes received · 10/12/2026
- React: useEffect runs twice in development
Liked by Jonah Weiss
My useEffect with an empty dependency array fires twice on mount, so my analytics event is sent twice. Is my component mounting twice?
Likes received · 10/12/2026
- Docker container exits immediately with code 0
FROM node:22-alpine WORKDIR /app COPY . . RUN npm ci CMD npm start & docker run returns right away and docker ps shows nothing. Logs are empty.
Likes given · 10/12/2026
- How do I select rows from a pandas DataFrame based on column values?
Liked by Jonah Weiss
I have a DataFrame of orders and want only the rows where status is "shipped" and total is above 100. In SQL: SELECT * FROM orders WHERE status = 'shipped' AND
Likes received · 10/12/2026
- C#: async void vs async Task
Only for event handlers. Exceptions from async void cannot be caught by the caller and crash the process; use async Task everywhere else.
Likes given · 10/12/2026
- Spark: how to avoid a shuffle when joining a small table?
Broadcast the small side: from pyspark.sql.functions import broadcast facts.join(broadcast(lookup), "country_code") Spark also does this automatically below spa
Likes given · 10/12/2026
- Spark: how to avoid a shuffle when joining a small table?
Liked by user3307719
Joining a 2 GB fact table with a 5 MB lookup table causes a full shuffle. Any way to avoid it?
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Dmitri Vasko
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Svetlana Orlova
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Ben Achterberg
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Keiko Arai
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Hollis Grant
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by user3307719
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Tomás Ferreira
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Lin Mei
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Mateus Brandão
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Async Python: run blocking code without freezing the event loop
Liked by Oskar Lindqvist
Push it to a thread: result = await asyncio.to_thread(blocking_fn, arg) For CPU-heavy work use a process pool with loop.run_in_executor(ProcessPoolExecutor(), f
Likes received · 10/12/2026
- Java: concurrent modification exception when removing from a list in a for-each loop
for (String s : names) { if (s.isBlank()) names.remove(s); } throws ConcurrentModificationException. How should I remove while iterating?
Likes given · 10/12/2026
- Kubernetes pod stuck in CrashLoopBackOff, no logs
--previous showed a missing env var. Thanks!
Likes given · 10/12/2026