Get a quick overview of how much data you are missing
It’s not uncommon to have gaps in your data. Whether the measurements were not correctly made,
or there’s simply missing data, it’s something we should consider and spend some time on before
doing anything else with our data.Graphext makes it very easy to spot where your data is missing and how much.Graphext can deal with null data no problem. The table will tell you if a cell is null, like this:
Most importantly, we can get a sense of how many null rows we have in each column by simply
checking out its corresponding little cross filter on the side:
The blue and white bar represents the whole dataset. The blue part indicates the currently selected
valid rows. The white, empty part refers to those rows whose value is null for this column.Moreover, we can select any of these sections, which will filter the data accordingly. This is useful to
check if there’s any reason behind the null values, or to get rid of all the null values altogether in
one single click.
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Documentation","colors":{"primary":"#0091e4","light":"#0091e4","dark":"#0091e4"},"favicon":"https://mintcdn.com/graphext/ce4nEaTZs1YrnQJO/favicon.svg?fit=max\u0026auto=format\u0026n=ce4nEaTZs1YrnQJO\u0026q=85\u0026s=8960ca35f91b01ba0ee9e11694953d19","logo":{"light":"https://mintcdn.com/graphext/HzS8XhzGDE5qDtO2/logo/graphext_light.svg?fit=max\u0026auto=format\u0026n=HzS8XhzGDE5qDtO2\u0026q=85\u0026s=29c0a888016f317dc3c5fff72433a3d0","dark":"https://mintcdn.com/graphext/HzS8XhzGDE5qDtO2/logo/graphext_dark.svg?fit=max\u0026auto=format\u0026n=HzS8XhzGDE5qDtO2\u0026q=85\u0026s=49f019370a4a578b7c0680d692a737b0"},"navbar":{"links":[{"label":"Support","href":"mailto:support@graphext.com"}],"primary":{"type":"button","label":"Sign up for free","href":"https://accounts.graphext.com/users/sign_up"}},"seo":{"indexing":"all"},"footer":{"socials":{"twitter":"https://twitter.com/graphext","youtube":"https://www.youtube.com/channel/UCJiSlA08Fgvg3WPu8x1dhCg","linkedin":"https://www.linkedin.com/company/graphext/"}},"fonts":{"family":"Lato"},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"graphext","hasAudioNarration":false,"actualSubdomain":"graphext","customDomains":["docs.graphext.com"],"gitSource":{"type":"github","owner":"graphext","repo":"documentation","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ac7b36a575228f4f5cf7df3","collectionId":"09e621fa-1f66-4d43-8d57-e854da9318bd","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ac7b36a575228f4f5cf7df3"},"feedback":{"thumbs":true,"edits":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6ac830f40666ed062fc15c83","clientVersion":"0.0.4044","searchFilterCounts":[{"language":"default","tag":"Documentation","count":54},{"language":"default","tag":"Data Preparation","count":25},{"language":"default","tag":"Variable Management \u0026 UI Config","count":14},{"language":"default","tag":"FAQs","count":14},{"language":"default","tag":"API Docs","count":13},{"language":"default","tag":"Concepts","count":11},{"language":"default","tag":"Data Visualization","count":10},{"language":"default","tag":"Data Enrichments","count":9},{"language":"default","tag":"Graphext concepts","count":8},{"language":"default","tag":"Data Exploration","count":7}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[],"page":{"pagePath":"documentation/data-preparation/sampling-data/view-nulls","slug":"/documentation/data-preparation/sampling-data/view-nulls","pageMetadata":{"title":"Dealing with nulls","description":"Get a quick overview of how much data you are missing","icon":"empty-set","href":"/documentation/data-preparation/sampling-data/view-nulls"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Get a quick overview of how much data you are missing\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,..._provideComponents(),...props.components},{Frame,OptimizedImage}=_components;if(!Frame)_missingMdxReference(`Frame`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`It’s not uncommon to have gaps in your data. Whether the measurements were not correctly made,\nor there’s simply missing data, it’s something we should consider and spend some time on before\ndoing anything else with our data.`}),`\n`,_jsx(_components.p,{children:`Graphext makes it very easy to spot where your data is missing and how much.`}),`\n`,_jsx(_components.p,{children:`Graphext can deal with null data no problem. The table will tell you if a cell is null, like this:`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=a642dc9e533da5c5f2fa1387ed03652b`,alt:`table nulls`,\"data-og-width\":`2130`,width:`2130`,\"data-og-height\":`1808`,height:`1808`,\"data-path\":`images/sampling-data/table-nulls.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?w=280\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=4f0aabbe4d90e71934cfe30cdf558f12 280w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?w=560\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=7c9b90c7add22eb521e0730a8c84e912 560w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?w=840\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=7ca16dc21417250c1c5b4104a40c87e8 840w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=7e982b9cb1c171aa3180d7281c1ce25e 1100w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=f2a628906715cb15a1bdd4c4e4f76f52 1650w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/table-nulls.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=e1aaadb432d9b109b0e96d6e079e9ab3 2500w`})}),`\n`,_jsx(_components.p,{children:`Most importantly, we can get a sense of how many null rows we have in each column by simply\nchecking out its corresponding little cross filter on the side:`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=38e9951c3eb236e396142b745d7a4066`,alt:`cross filter nulls`,\"data-og-width\":`1251`,width:`1251`,\"data-og-height\":`1169`,height:`1169`,\"data-path\":`images/sampling-data/null-hover.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?w=280\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=b8c7af451ade33af03b12635dd36c8b8 280w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?w=560\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=014cb6794b1f49aef2129b7827b96d43 560w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?w=840\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=9e922fa41491b043a1a327156876d5cd 840w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=5c91c36852114b382e62e10f288376a1 1100w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=59289fcbd876676302fff7d49f46de5f 1650w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-hover.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=d6f9aab9f10c818b54f5dc336562cfb6 2500w`})}),`\n`,_jsxs(_components.p,{children:[`The blue and white bar represents the whole dataset. The blue part indicates the currently selected\nvalid rows. The white, empty part refers to those rows whose value is `,_jsx(_components.code,{children:`null`}),` for this column.`]}),`\n`,_jsx(_components.p,{children:`Moreover, we can select any of these sections, which will filter the data accordingly. This is useful to\ncheck if there’s any reason behind the null values, or to get rid of all the null values altogether in\none single click.`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=fb9e9ef7004def845ba54968e5c265bf`,alt:`null selected`,\"data-og-width\":`1202`,width:`1202`,\"data-og-height\":`1090`,height:`1090`,\"data-path\":`images/sampling-data/null-selected.webp`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?w=280\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=481453f1c2c2d41d0f151cab043522c7 280w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?w=560\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=75f33d21ac96265c17c29f50271c2be5 560w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?w=840\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=b135e7dd1001076bfe7b0c63417f8165 840w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?w=1100\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=75bd20beb16c795402214ee2b28417f8 1100w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?w=1650\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=598bc87c6a6d841ebbaf36ea016bd785 1650w, https://mintcdn.com/graphext/fZjz0m5J_8c25YMy/images/sampling-data/null-selected.webp?w=2500\u0026fit=max\u0026auto=format\u0026n=fZjz0m5J_8c25YMy\u0026q=85\u0026s=0d1ddb4bb95928caa38d9aeadcd15645 2500w`})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Dealing with nulls","description":"Get a quick overview of how much data you are missing","icon":"empty-set","href":"/documentation/data-preparation/sampling-data/view-nulls"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"graphext","siteName":"Documentation","title":"Dealing with nulls - Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-07T00:48:12.657Z","originalFileLocation":"documentation/data-preparation/sampling-data/view-nulls.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Get a quick overview of how much data you are missing\">\u003cmeta data-mint-head name=\"application-name\" content=\"Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Dealing with nulls - Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Get a quick overview of how much data you are missing\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://graphext.mintlify.app/_mintlify/api/og/v2?division=Sampling+Data\u0026amp;title=Dealing+with+nulls\u0026amp;description=Get+a+quick+overview+of+how+much+data+you+are+missing\u0026amp;theme=9002734ec1988eb29b089078\u0026amp;signature=864a46e37b9aa90072fb2be6f566b17cd55d26367a71d04c084012239a70927f\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Dealing with nulls - Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Get a quick overview of how much data you are missing\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://graphext.mintlify.app/_mintlify/api/og/v2?division=Sampling+Data\u0026amp;title=Dealing+with+nulls\u0026amp;description=Get+a+quick+overview+of+how+much+data+you+are+missing\u0026amp;theme=9002734ec1988eb29b089078\u0026amp;signature=864a46e37b9aa90072fb2be6f566b17cd55d26367a71d04c084012239a70927f\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/graphext/7E-c6JbOGQAc_i7p/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#0091e4\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/documentation/data-preparation/sampling-data/view-nulls.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.graphext.com/#organization\",\"name\":\"Documentation\",\"url\":\"https://docs.graphext.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/graphext/HzS8XhzGDE5qDtO2/logo/graphext_light.svg?fit=max\u0026auto=format\u0026n=HzS8XhzGDE5qDtO2\u0026q=85\u0026s=29c0a888016f317dc3c5fff72433a3d0\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.graphext.com#website\",\"name\":\"Documentation\",\"url\":\"https://docs.graphext.com\",\"publisher\":{\"@id\":\"https://docs.graphext.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls#webpage\",\"url\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls\",\"name\":\"Dealing with nulls\",\"description\":\"Get a quick overview of how much data you are missing\",\"dateModified\":\"2026-01-07T00:48:12.657Z\",\"isPartOf\":{\"@id\":\"https://docs.graphext.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Data Preparation\",\"item\":\"https://docs.graphext.com/documentation/data-preparation/variable-management-ui-config/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dealing with nulls\",\"item\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls#article\",\"headline\":\"Dealing with nulls\",\"name\":\"Dealing with nulls\",\"description\":\"Get a quick overview of how much data you are missing\",\"url\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls\",\"mainEntityOfPage\":{\"@id\":\"https://docs.graphext.com/documentation/data-preparation/sampling-data/view-nulls#webpage\"},\"dateModified\":\"2026-01-07T00:48:12.657Z\",\"publisher\":{\"@id\":\"https://docs.graphext.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.graphext.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Documentation\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Documentation","nav":{"global":null,"tabs":[{"tab":"Documentation","groups":[{"group":"Getting Started","pages":[{"title":"What is Graphext?","mode":"wide","icon":"question","href":"/documentation/getting-started/what-is-graphext"},{"title":"Graphext 101","icon":"graduation-cap","href":"/documentation/getting-started/quickstart"}]},{"group":"Import and Export Data","pages":[{"title":"Import data files","icon":"file-import","href":"/documentation/import-and-export/import-files"},{"title":"Import from Integrations","icon":"plug-circle-plus","href":"/documentation/integrations/data-sources/overview"},{"title":"Update your data recurrently","icon":"repeat","href":"/documentation/import-and-export/update-data"},{"title":"Export your data","icon":"file-export","href":"/documentation/import-and-export/export-data"}]},{"group":"Data Exploration","pages":[{"group":"Cross Filters","icon":"object-intersect","pages":[{"title":"Overview","icon":"map","href":"/documentation/data-exploration/cross-filters/overview"},{"title":"Advanced data selection","icon":"arrow-pointer","href":"/documentation/data-exploration/cross-filters/advanced-selection"},{"title":"Significant Variables","icon":"ruler-horizontal","href":"/documentation/data-exploration/cross-filters/significant-variables"},{"title":"Segments","icon":"diagram-previous","href":"/documentation/data-exploration/cross-filters/creating-segments"}]},{"title":"The Compare tab","icon":"code-compare","href":"/documentation/data-exploration/compare"},{"title":"The Correlations tab","icon":"diagram-venn","href":"/documentation/data-exploration/correlations"},{"title":"Advanced Filter Queries","icon":"arrow-pointer","href":"/documentation/data-exploration/advanced-filter-queries"}]},{"group":"Data Visualization","pages":[{"title":"Choosing a chart","icon":"chart-simple","href":"/documentation/data-visualization/choosing-a-chart"},{"title":"Customizing Charts","icon":"brush","href":"/documentation/data-visualization/customizing-charts"},{"group":"Types of Chart","icon":"chart-scatter-bubble","pages":[{"title":"Overview","icon":"map","href":"/documentation/data-visualization/types-of-chart/overview"},{"title":"Line Chart","icon":"chart-line","href":"/documentation/data-visualization/types-of-chart/line-chart"},{"title":"Area Chart","icon":"chart-area","href":"/documentation/data-visualization/types-of-chart/area-chart"},{"title":"Bar Chart","icon":"chart-simple","href":"/documentation/data-visualization/types-of-chart/bar-chart"},{"title":"Scatter Plot","icon":"chart-scatter","href":"/documentation/data-visualization/types-of-chart/scatter-plot"},{"title":"Box Plot","icon":"chart-candlestick","href":"/documentation/data-visualization/types-of-chart/box-plot"},{"title":"Heatmap","icon":"game-board","href":"/documentation/data-visualization/types-of-chart/heatmap"}]},{"title":"Exporting charts","icon":"download","href":"/documentation/data-visualization/exporting-charts"}]},{"group":"Data Preparation","pages":[{"group":"Variable Management \u0026 UI Config","pages":[{"title":"Overview","icon":"map","href":"/documentation/data-preparation/variable-management-ui-config/overview"},{"group":"Variable Management","pages":[{"title":"Hide a variable","icon":"eye-slash","href":"/documentation/data-preparation/variable-management-ui-config/hide-variable"},{"title":"Rename a variable","icon":"input-text","href":"/documentation/data-preparation/variable-management-ui-config/change-variable-name"},{"title":"Adding variable descriptions","icon":"file-signature","href":"/documentation/data-preparation/variable-management-ui-config/add-variable-description"},{"title":"Delete a variable","icon":"trash-can","href":"/documentation/data-preparation/variable-management-ui-config/delete-variable"},{"title":"Editing segments","icon":"diagram-previous","href":"/documentation/data-preparation/variable-management-ui-config/editing-segments"},{"title":"Specifying order in categorical variables","icon":"arrow-down-1-9","href":"/documentation/data-preparation/variable-management-ui-config/specify-order-in-column"}]},{"group":"Data Table Management","pages":[{"title":"Arrange columns in the Data Table","icon":"arrow-right-arrow-left","href":"/documentation/data-preparation/variable-management-ui-config/arrange-columns-data-table"},{"title":"Sort the Data Table","icon":"arrow-down-wide-short","href":"/documentation/data-preparation/variable-management-ui-config/sort-data-table"},{"title":"Freeze columns in the data table","icon":"lock-keyhole","href":"/documentation/data-preparation/variable-management-ui-config/freeze-columns-table"}]},{"group":"UI Customization","pages":[{"title":"Group variables using tags","icon":"tag","href":"/documentation/data-preparation/variable-management-ui-config/group-variables"},{"title":"Pin variables","icon":"thumbtack","href":"/documentation/data-preparation/variable-management-ui-config/pin-variables-menu"},{"title":"Arrange variable order","icon":"arrows-up-down-left-right","href":"/documentation/data-preparation/variable-management-ui-config/arrange-variables-menu"}]},{"group":"Dataset metadata","pages":[{"title":"Add dataset information","icon":"subtitles","description":null,"href":"/documentation/data-preparation/variable-management-ui-config/add-dataset-description"}]}]},{"group":"Sampling Data","pages":[{"title":"Dealing with nulls","icon":"empty-set","href":"/documentation/data-preparation/sampling-data/view-nulls"},{"title":"Finding data","description":"Search for anything within your dataset","icon":"magnifying-glass","href":"/documentation/data-preparation/sampling-data/finding-data"}]},{"group":"Data Enrichments","pages":[{"title":"Overview","icon":"eye","href":"/documentation/data-preparation/data-enrichments/overview"},{"title":"Upsample Survey Data","icon":"ballot-check","href":"/documentation/data-preparation/data-enrichments/upsample-survey-data"},{"title":"Fill Missing Values","icon":"braille","href":"/documentation/data-preparation/data-enrichments/fill-missing-values"},{"title":"Predict Missing Values","icon":"arrow-up-right-dots","href":"/documentation/data-preparation/data-enrichments/predict-missing-values"},{"title":"Group Similar Spellings","icon":"spell-check","href":"/documentation/data-preparation/data-enrichments/group-similar-spellings"},{"title":"Group Similar Semantics","icon":"messages","href":"/documentation/data-preparation/data-enrichments/group-similar-semantics"},{"title":"Infer Gender","icon":"venus-mars","href":"/documentation/data-preparation/data-enrichments/infer-gender"},{"title":"Standardize Locations","icon":"map-location-dot","href":"/documentation/data-preparation/data-enrichments/standardize-locations"},{"title":"Add Demographic Data for Spain using coordinates","icon":"users-medical","href":"/documentation/data-preparation/data-enrichments/spanish-demographic-coordinate-data"}]}]},{"group":"Share, Present and Publish","pages":[{"title":"Saving insights in a project","icon":"lightbulb-exclamation-on","href":"/documentation/share-present-publish/saving-insights"},{"title":"Export plots \u0026 charts","icon":"download","href":"/documentation/share-present-publish/export-plots-and-chart"},{"title":"Sharing an interactive project","icon":"globe-pointer","href":"/documentation/share-present-publish/share-an-interactive-projects"}]},{"group":"Manage Workspace","pages":[{"title":"Account Settings","icon":"gear","href":"/documentation/manage-workspace/account-settings"},{"title":"Manage teams","icon":"screen-users","href":"/documentation/manage-workspace/manage-teams"},{"title":"Manage projects","icon":"rectangle-history","href":"/documentation/manage-workspace/manage-projects"}]}]},{"tab":"Tutorials","pages":[{"title":"Tutorials","href":"/tutorials/tutorials"}]},{"tab":"Concepts","pages":[{"title":"Concepts","href":"/concepts/graphext-concepts/recipe"}]},{"tab":"API Docs","pages":[{"title":"API Docs","href":"/api-docs/prepare/aggregate"}]},{"tab":"FAQs","pages":[{"title":"FAQs","href":"/faqs/intro-to-graphext"}]}]},"basePath":"","title":"Dealing with nulls - Documentation","buildId":"dpl_DeHjVRGfFnhYQwHnfC2pjeXXv8h9","deploymentId":"dpl_DeHjVRGfFnhYQwHnfC2pjeXXv8h9","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-DXXFP6nH.js","DynamicMarkdown-B54_zNBF.js","zoom-image-lightbox-BG6oD64b.js","lightbox-handle-r17bVUz3.js"]}