2c:null 2d:["$","title",null,{"children":"IH Summary | Askar Yusupov | Observable"}] 32:[] 30:{"id":"35d84beef595a98f","slug":"ih-summary","title":"IH Summary","thumbnail":"118e3d9ac0d45a6037ee583121cbb982b1147c872f9be202f2a7bfaf914f6bb1","access_level":"public","create_time":"$D2020-12-15T13:13:10.756Z","update_time":"$D2020-12-16T04:06:48.618Z","view_time":null,"first_public_time":"$D2020-12-15T16:24:38.178Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"20385a610af7c74a","login":"pyoner","name":"Askar Yusupov","avatar_url":"https://avatars-next.observableusercontent.com/45b125d5dc6577d6b31861174226b887031d8037e94053147c535955484e00ea","tier":"starter_2024"},"version":165,"publish_version":165,"role":null,"authored":false,"authors":[{"type":"individual","id":"9979be8e9c167fb7","login":"pyoner","name":"Askar Yusupov","avatar_url":"https://avatars-next.observableusercontent.com/45b125d5dc6577d6b31861174226b887031d8037e94053147c535955484e00ea","tier":null}],"members":[{"type":"individual","id":"9979be8e9c167fb7","login":"pyoner","name":"Askar Yusupov","avatar_url":"https://avatars-next.observableusercontent.com/45b125d5dc6577d6b31861174226b887031d8037e94053147c535955484e00ea","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"IH Summary","cells":[{"id":0,"value":"md`# IH Summary\n[INDIE HACKERS](https://www.indiehackers.com/) statistics (filtered by Stripe revenue verification )`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"md`## Story\nI have an idea to build a project for data visualization and analysis [Indie Hackers](https://www.indiehackers.com/) site. For the project I needed the data, but I did't have it.\nA week ago I started building the project...`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"md`## The project tools\nI've written a CLI program in Typescript. It consist of three commands **\"parse\"**, **\"normalize\"** and **\"merge\"**.\n\nThe **\"parse\"** command simply extracts the data and saves it to files. \n\nThe **\"normalize\"** command gets the data from the files and starts data normalization. The parsed data includes *\"country\"*, *\"region\"*, *\"city\"* fields written in different languages, which need to be normalized. For this task, I've written a function that transforms the data using Google geocoding. It is not fast process, because it needs to talk with the Google geocoding API, but to speed up the process, I created a cache based on LevelDB. The next step is split tags to the different fields like \"category\", \"platform\", \"founders\", etc. This step takes time to analyze the data. In the end, after completing all the normalization steps, I had all the data to start analyzing.\n\nThe **\"merge\"** command takes the normalized data and merges it into one file.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"md`## Data analysis tools\nI'm not a data analyst at all, I'm a web developer :)\nI started looking for data visualization tools. \n\n* [Airtable](https://airtable.com/) - cool tool have some restrictions, new for me\n* [Python](https://www.python.org/), [pandas](https://pandas.pydata.org/), [numpy](https://numpy.org/) - I know Python, but I haven't practiced for a long time. I don't know pandas, numpy :(\n* [Streamlit](https://www.streamlit.io/) - nice tool, I like it but Python, pandas, numpy under the hood (maybe next time)\n* [Zebras](http://zebrasjs.com/), [danfo.js](https://danfo.jsdata.org/) - good tools, like pandas (I'll try it)\n* [Observablehq](https://observablehq.com/) - awesome platform! (I use it)\n* [MongoDB Charts](https://www.mongodb.com/products/charts) - a tool for web developers! I'm familiar with MongoDB query (I use, my recommendation)\n\nFinally I've chosen Observablehq + MongoDB Charts`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"md`## Let's build charts\nNote: the analysis is based on limited data grouped by 'wordpress' category and filtered by Stripe revenue verification!`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"md`### Revenue table grouped by country`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"md`### Revenue model`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"md`### Founders`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"md`### Founders tech skills`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"md`### Employees`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"md`### Funding`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"md`### Customers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`### Initial commitment`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"md`### Social networks`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"md`### Start date`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"md`### Platform`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1"}} 31:"$30:body"