PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 23 hours 22 minutes 45 seconds

Memory

Total
512MB
Used
12,72MB (2.48%)
Free
499,28MB

Keys

Current
14 060
Total (since start)
40 994
Evictions
0
Reclaimed
760
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
14 / 1 024 max
Total
193 541
Rejected
0
llm:93a5630748fbfca427f89a898c98d916eb63b5517f42ce216768bbb310ab2b10
TTL 6 days 4 hours 1 minute 35 seconds Size 2,66KB Export
Edit
Yes. The most natural segmentation is by **funding stage**, then by **location** and **sector**. Announcement month is a fifth option, because each month is its own table. **1. Funding stage (the primary segmentation)** - The stage query covers all 446 rows (step-3). The main groups are: - Seed, 73 rows. - Series A, 56 rows. - Pre-series A, 37 rows. - Series B, 26 rows. - Series C, 19 rows. - Series D, 14 rows. - Series E and F, 11 and 12 rows. - Pre-seed, 8 rows. - Series G, H and J, each with only a few rows. - This maps onto early stage (Pre-seed, Seed, Pre-series A, Series A), growth (Series B to D) and late stage (Series E and beyond). - Two groups are not real stages: 127 rows have a blank stage and 37 are "undisclosed". Together that is about 37% of the data (164 of 446 rows). **2. Location (geographic segmentation)** - Funding is concentrated in a few cities (step-1): - Bangalore, 124 rows. - Mumbai, 62. - Gurgaon, 48. - New Delhi, 31. - Chennai, 27. - Noida, Hyderabad and Pune, 12 to 15 each. - 20 rows have a blank location. **3. Sector (industry segmentation)** - Financial Services is the largest sector with 59 rows, plus another 13 under the variant spelling "Financial services". - Next come Information Technology & Services (27), Computer Software (26), Health, Wellness & Fitness (15), E-learning (12), E-commerce (12) and Food & Beverages (11). - The sector list is long, roughly 40 to 55 distinct values per month, so it needs rolling up into broader groups such as fintech, software/IT, health, edtech, commerce and food. - 19 rows have a blank sector. **4. Announcement month** - January has 115 rows, February 96, March 98, April 95 and May 42. May is smaller and has some misaligned or blank rows. - Each month is a separate table with identical columns, so a combined view would need a union of the five tables. **Cleaning needed before grouping** - **Inconsistent labels:** "Bangalore" and "Bengaluru" are the same city, "Financial Services" and "Financial services" are the same sector, and "Pre-seed" and "Preseed" are the same stage. "Series-D", "$Series A", "Undiclosed" and "Unknown" are also variants or typos. - **Misplaced values:** one stage value is actually an investor list ("Blue Ashva Capital, Supack Industries"). This fits the note that some May rows are misaligned. - **Amount:** it is stored as text, so it would have to be parsed before being used to segment by deal size. A reasonable scheme is stage group (early, growth, late, undisclosed) crossed with a normalized city and a rolled-up sector.