PHPMem v2.0.1

Version
1.6.45
Uptime
18 days 4 hours 46 minutes 49 seconds

Memory

Total
512MB
Used
12,33MB (2.41%)
Free
499,67MB

Keys

Current
13 424
Total (since start)
40 994
Evictions
0
Reclaimed
762
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
3 / 1 024 max
Total
244 001
Rejected
0
llm:a7ce59223f2f00c1df2fff3e2d6b739306b205a8db588bdd05c1b0a0a419c808
TTL 4 days 22 hours 27 minutes 8 seconds Size 2,62KB Export
Edit
{
    "action": "final",
    "content": "**Yes, but only a few true duplicates. Most repeats are the same company appearing in different months.**\n\nI compared company names across the five monthly tables (Jan–May 2022, 446 rows in total). Excluding the blank company names, 14 companies appear more than once (step-4).\n\n**1. Exact or near-exact duplicates within one month (data-entry repeats)**\n- **nowpurchase** appears twice in January with the same $2,400,000 Seed round.\n- **securden** appears twice in April with the same Series A round. The amount is written as `$11.700,000` in one row and `$11,700,000` in the other, so this is a near-duplicate caused by inconsistent number formatting.\n\n**2. Same company across different months (probably separate rounds, not duplicates)**\nThe other 12 repeating companies each have one row in two or more different months, with different amounts.\n- **pine labs** appears in all four months from Jan to Apr: $20M in Jan, $150M in Feb, $50M in Mar and $1.2B in Apr.\n- **lummo** shows $80,000,000 in both Jan and Feb, both labelled Series C. This could be a repeated announcement of one round, so it needs checking.\n- **swiggy**, **mamaearth**, **chargebee**, **classplus**, **dealshare**, **licious**, **livspace**, **xpressbees**, **growfitter** and **sustainkart** each appear in two months with different amounts or stages.\n- Several of these are probably distinct rounds. However, the Stage values sometimes repeat across months, as with xpressbees (Series F in both Feb and Apr) and livspace (Series F in both Feb and Apr). These deserve a manual check.\n\n**3. Data quality issues that affect duplicate detection**\n- Amount is stored as text with inconsistent formats, such as `$468.200,000` versus `$250,000,000`, and one value of `$431.6` for livspace. Matching on exact amount strings will miss near-duplicates, as it would have for securden.\n- The May table has about 19 blank or misaligned rows. They all show blank company, amount and stage, apart from one row with `6400000 / $Series A` and no company name. These are empty placeholders rather than real duplicates, but they will look like duplicates if you group on the blank company.\n\n**Bottom line:** two clear duplicate pairs (nowpurchase and securden), one possible repeated announcement (lummo), and about 19 blank or misaligned rows in May. Everything else is the same company legitimately raising money in several months. Before analysing, I would remove the two duplicates, normalise the Amount strings and drop the blank May rows."
}