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
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.