Micah
Micah
  • 809
  • 1 357 691
How to turn NaN and floats into integers by using Pandas dataframe (df)
#pandas #nan #float #dataanalysis
In this tutorial, learn how to convert NaN values and float numbers to integers using pandas DataFrame in Python. We'll cover step-by-step methods to handle missing data (NaN) and transform float data types into integers. This guide is perfect for data scientists and analysts looking to clean and preprocess their datasets for further analysis.
This link also shows how to do this - www.geeksforgeeks.org/how-to-fix-valueerror-cannot-convert-float-nan-to-integer/
Переглядів: 44

Відео

How to Scrape and Clean Real Estate Data in Excel & Google Chrome (EASY TUTORIAL)
Переглядів 3214 днів тому
#excel #datascraping #scraping #dataanalysis Learn how to scrape and clean real estate data using Excel and Google Chrome in this easy tutorial! I will guide you through the process of extracting data from websites and organizing it in Excel for analysis. Perfect for beginners and professionals looking to enhance their data skills.
How to batch geocode addresses with the ArcGIS API for python and python pandas
Переглядів 2114 днів тому
#arcgis #geocode #geospatial Check out the official documentation here for more info - developers.arcgis.com/python/guide/part4-batch-geocoding/ This blog only represents myself, no other entity. Learn how to batch geocode addresses using the ArcGIS API for Python and pandas! This tutorial walks you through the process of geocoding multiple addresses efficiently with Python scripting. Perfect f...
How to Create Crime Heat Maps Using ArcGIS for Excel
Переглядів 3521 день тому
#excel #arcgis #heatmap Main video here with all steps - ua-cam.com/video/Os3TA1v1f08/v-deo.html
Master Excel Layer Visibility in Minutes!
Переглядів 3321 день тому
Master Excel Layer Visibility in Minutes!
How to use Analyze Data Tab and Insert Automated Pivot Tables In Excel
Переглядів 3628 днів тому
#excel #analyzedata #pivottables This video shows you how to make use of the analyze data tab and guides you through creating pivot tables in an automatic way.
How to Share and Print Map in Google My Maps
Переглядів 9928 днів тому
#googlemymaps #mapping #gis In this tutorial, I'll will show you step-by-step how to share and print maps using Google My Maps. Whether you're collaborating with a team, planning a trip, or simply want to create a physical copy of your map, this video will guide you through the entire process. Use it here - www.google.com/maps/d/u/0/ The example data if you want to use the same data for your pr...
Calculate Address in Excel with ArcGIS for Excel Add In Function Builder
Переглядів 35Місяць тому
#arcgis #excel #gis Just a simple video showing you how to setup and use ArcGIS for Excel to calculate an address. This video is just a blog and does not represent anyone other than myself. Check out the ArcGIS for Excel documentation here - doc.arcgis.com/en/microsoft-365/latest/excel/get-started-with-arcgis-for-excel.htm Use the sample data within for your own project here - github.com/coldap...
How to Make Heatmap in Excel ArcGIS Add In
Переглядів 49Місяць тому
#excel #arcgis #arcgisforexcel #howto Just a simple video showing you how to create a heatmap in ArcGIS for Excel. This video is just a blog and does not represent anyone other than myself. Check out the ArcGIS for Excel documentation here - doc.arcgis.com/en/microsoft-365/latest/excel/get-started-with-arcgis-for-excel.htm Use the sample data within for your own project here - github.com/coldap...
How to Setup and Use ArcGIS Excel Add In
Переглядів 52Місяць тому
#excel #arcgis #arcgisforexcel #howto Just a simple video showing you how to setup and use ArcGIS for Excel. This video is just a blog and does not represent anyone other than myself. Check out the ArcGIS for Excel documentation here - doc.arcgis.com/en/microsoft-365/latest/excel/get-started-with-arcgis-for-excel.htm Use the sample data within for your own project here - github.com/coldapache/B...
Google My Maps How to Edit Table of Data Add Records
Переглядів 151Місяць тому
#googlemymaps #mapping #maptable This video shows you how to edit and add records in a table within Google My Maps. - www.google.com/maps/d/u/0/ Crime dataset exists here if you would like to download it and use it for your own project - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore Crime Data July 2024.csv View Data Table (0:00 - 0:20) Search and Select Records (0:21 - 0...
How to Use Leonardo Phoenix and Prompt Enhance
Переглядів 697Місяць тому
#leonardoai #leonardophoenix #aihowto This video shows you how to use the Leonardo.Ai Phoenix model to generate images with text. Custom Leonardo GPT (for leonardo prompt creation help) - chat.openai.com/g/g-p21BAlj12-leonardo-ai-image-prompt-analyst Both Leonardo and LimeWire provide free tokens/trials. Leonardo - app.leonardo.ai/?via=micah LimeWire - limewire.com/studio?referrer=kl1nkaroir Le...
How to Sort Date Times in Microsoft Excel Quick Guide (EASY DATA ANALYSIS TECHNIQUE)
Переглядів 70Місяць тому
#excel #time #sorting #analysis This video quickly shows you how to sort date time values for your whole dataset in excel. Follow along with this data - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore Crime Data July 2024.csv Introduction to Time Sorting in Excel - 00:00-00:10 Dataset Overview - 00:11-00:20 Selecting the Column for Sorting - 00:21-00:30 Accessing the Sort F...
How to Visualize Crime Data on Google My Maps (EASY)
Переглядів 246Місяць тому
#data #googlemymaps #howto #crimedata This video shows how to put crime data onto Google My Maps - www.google.com/maps/d/u/0/ Crime dataset exists here if you would like to download it and use it for your own project - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore Crime Data July 2024.csv
Data Resource: FEMA Data National Risk Index Map - Download Weather Risk Datasets
Переглядів 35Місяць тому
#GIS #FEMA #data Check out this map/website here - hazards.fema.gov/nri/map (downloadable data)
How to use ChatGPT with Mermaid Charts
Переглядів 58Місяць тому
How to use ChatGPT with Mermaid Charts
How to Create Dark Theme Editor Widget in ArcGIS SDK for JavaScript (Code Included)
Переглядів 24Місяць тому
How to Create Dark Theme Editor Widget in ArcGIS SDK for JavaScript (Code Included)
NetworkX Link Chart on Map Using Python [ How to Guide with Code ]
Переглядів 911Місяць тому
NetworkX Link Chart on Map Using Python [ How to Guide with Code ]
Texas DOT Open Data Resources for Data Science/GIS and How to Make a Simple Map in Python
Переглядів 61Місяць тому
Texas DOT Open Data Resources for Data Science/GIS and How to Make a Simple Map in Python
How to Configure ArcGIS Knowledge Link Charts to Display on a Map (Basic Config Guide/Blog)
Переглядів 46Місяць тому
How to Configure ArcGIS Knowledge Link Charts to Display on a Map (Basic Config Guide/Blog)
How to Configure ArcGIS Knowledge Graph Entity Relationship (Basic Explanation/Blog)
Переглядів 43Місяць тому
How to Configure ArcGIS Knowledge Graph Entity Relationship (Basic Explanation/Blog)
USGS Water Level Visualization Animation Map
Переглядів 55Місяць тому
USGS Water Level Visualization Animation Map
Visualize Trillions: A Walkthrough of Treemap Charts and Global Spending
Переглядів 29Місяць тому
Visualize Trillions: A Walkthrough of Treemap Charts and Global Spending
Data Exploration - PFAS Chemical Contamination Map for USA
Переглядів 662 місяці тому
Data Exploration - PFAS Chemical Contamination Map for USA
OECD Average Wage Data by Country - Build Data Analysis Charts with ChatGPT
Переглядів 352 місяці тому
OECD Average Wage Data by Country - Build Data Analysis Charts with ChatGPT
Efficient Project Management with Specialized Apps Transforming Data into Actionable Insights
Переглядів 534 місяці тому
Efficient Project Management with Specialized Apps Transforming Data into Actionable Insights
Open vs Closed Prompts Demonstrated in ChatGPT [ Discussion ]
Переглядів 1374 місяці тому
Open vs Closed Prompts Demonstrated in ChatGPT [ Discussion ]
Boost Your Business Efficiency with an Organized SQL Database
Переглядів 264 місяці тому
Boost Your Business Efficiency with an Organized SQL Database
Ai Generated Lofi Music Limewire [ Free and Easy ]
Переглядів 1134 місяці тому
Ai Generated Lofi Music Limewire [ Free and Easy ]
Image Prompt Posing Guide with Leonardo Ai & ChatGPT
Переглядів 7785 місяців тому
Image Prompt Posing Guide with Leonardo Ai & ChatGPT

КОМЕНТАРІ

  • @ibrahimgidi1024
    @ibrahimgidi1024 7 днів тому

    finally i have tried every solution untill i get your video thanks very much

  • @IfekasKitchen
    @IfekasKitchen 8 днів тому

    I signed out totally to make it work

  • @ManggarOutsiders
    @ManggarOutsiders 15 днів тому

    Nice Spyderco!

    • @MicahJohns
      @MicahJohns 15 днів тому

      Thanks! Out of all the comments I think you're the only one who noticed that.

  • @FluffyPandaBeard
    @FluffyPandaBeard 16 днів тому

    Great video thanks for the upload 🐼👍

  • @AndrewFrancis-th5pf
    @AndrewFrancis-th5pf 17 днів тому

    Tarantulas do use digestive enzymes, and that's a male dubia roach, not a Madagascar hissing cockroach.

  • @IQUniverse_
    @IQUniverse_ 22 дні тому

    make a tutorial on making photos of cars and how they move, I want to know how

  • @cokomairena
    @cokomairena 26 днів тому

    Do you know how to open a route you make on mymaps on regular google maps?

  • @MicahJohns
    @MicahJohns 29 днів тому

    Introduction to ArcGIS for Excel Add-in - 00:00-00:10 Opening the Function Builder - 00:11-00:25 Using the Get Address Function - 00:26-00:45 Entering Coordinates and Calculating Address - 00:46-01:10 Inserting the Address Formula - 01:11-01:20 Breakout Address Columns Option - 01:21-01:40 Updating and Naming Columns Correctly - 01:41-01:50 Applying the Formula to Multiple Rows - 01:51-02:00

  • @MicahJohns
    @MicahJohns 29 днів тому

    Use it here - www.google.com/maps/d/u/0/ The example data if you want to use the same data for your project - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore%20Crime%20Data%20July%202024.csv

  • @dmytrokravets2264
    @dmytrokravets2264 Місяць тому

    Best explanation on how to save files in GoogleEarth. Thank you!

    • @MicahJohns
      @MicahJohns 29 днів тому

      thanks for watching, glad it was helpful

  • @jessiejackson8502
    @jessiejackson8502 Місяць тому

    So...more women charged with more crimes involving weapons than men.... Gotcha, thanks! 🙃

    • @MicahJohns
      @MicahJohns 29 днів тому

      Lol, understand this dataset is very filtered. I wouldn’t take that output as a truth statistic for all of Baltimore. I think I have like 14 days of July in here.

  • @MicahJohns
    @MicahJohns Місяць тому

    Steps to Use Google My Maps View Data Table Click on layer options and select Open Data Table. You can navigate and edit records directly from the data table. Search and Select Records Use the search function to find specific records (e.g., search for "homicide"). Hover over and select records to see them highlighted on the map. Edit Records Click on a record in the data table to edit its values. Add New Data Row Click Add Row to create a new entry in the data table. Enter the details for the new data point. Replace with Marker Right-click at the edge of a row and select Replace with Marker. Click on the map to place the new marker for the selected record. Fill out the details and click Save. Enhance Data Points Add images or videos to data points. Style data points or get directions to them. Delete data points if necessary. Save and Name Your Map Click at the top to save your map project. Name your map (e.g., "Baltimore Crime Map July 2024") and add a description. Preview and Share Map Click Preview to see how the map will look when shared. Use the Share function to generate a link to share the map with others.

  • @MicahJohns
    @MicahJohns Місяць тому

    Steps to Create a Heat Map Using ArcGIS for Excel Introduction (0:00 - 0:05) Brief overview of what will be covered in the video. Prepare Your Data and Layers (0:06 - 0:30) Ensure your Excel sheet has the data ready. Add a layer with the location points. Creating a Heat Map (0:31 - 0:45) Select the layer and choose to display it as a heat map. Compare the difference between location points and the heat map view. Adjusting Color Ramp (0:46 - 1:20) Access the color palette to pick your preferred color ramp. Options include "red hot, blue cold" or other combinations like "purple and gold." Modify the colors to highlight high and low areas effectively. Modifying Heat Map Settings (1:21 - 1:50) Adjust the blur radius for a more concentrated or dispersed heat map. Tweak the settings to ensure the heat map visibility aligns with your data needs. Layer Visibility and Properties (1:51 - 3:15) Toggle between different layers to show or hide them as needed. Zoom in to see detailed points, zoom out to see the heat map. Change layer visibility properties to manage when layers become visible. Set the visible range to control at what zoom levels the heat map and points appear. Using Heat Maps for Data Exploration (3:16 - 3:30) Utilize heat maps to identify pockets of activity. Investigate specific areas highlighted by the heat map to find detailed incidents or data points.

  • @MicahJohns
    @MicahJohns Місяць тому

    Check out the ArcGIS for Excel documentation here - doc.arcgis.com/en/microsoft-365/latest/excel/get-started-with-arcgis-for-excel.htm Use the sample data within for your own project here - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore%20Crime%20Data%20July%202024.csv

  • @MicahJohns
    @MicahJohns Місяць тому

    Steps to Use ArcGIS for Excel Install the ArcGIS Add-In: Open Excel. Click on the File menu in the top left corner. Select Get Add-ins. Search for ArcGIS and add it to Excel. Login to ArcGIS Online: Once added, click on the ArcGIS banner in Excel. Click on Show Map. Log in with your ArcGIS Online account. Prepare Your Data: Ensure you have spatial data ready in your Excel sheet. The add-in will prompt you to specify which columns contain spatial information. Create and Explore the Map: Select your spatial columns to display the data on the map. Use basic functionalities to explore the map. Filter and Analyze Data: For example, to filter by crime type: Click on the column containing crime types. Use the filter function to select specific crime types (e.g., auto theft). The map will update to show only the filtered data. Perform additional analysis as needed.

  • @MicahJohns
    @MicahJohns Місяць тому

    Check out the ArcGIS for Excel documentation here - doc.arcgis.com/en/microsoft-365/latest/excel/get-started-with-arcgis-for-excel.htm Use the sample data within for your own project here - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore%20Crime%20Data%20July%202024.csv

  • @MicahJohns
    @MicahJohns Місяць тому

    This video shows you how to edit and add records in a table within Google My Maps. - www.google.com/maps/d/u/0/ Crime dataset exists here if you would like to download it and use it for your own project - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore%20Crime%20Data%20July%202024.csv

  • @PowWowDAO
    @PowWowDAO Місяць тому

    Cool. Thank you!

  • @MicahJohns
    @MicahJohns Місяць тому

    This video quickly shows you how to sort date time values for your whole dataset in excel. Follow along with this data - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore%20Crime%20Data%20July%202024.csv

  • @MicahJohns
    @MicahJohns Місяць тому

    This video shows how to put crime data onto Google My Maps - www.google.com/maps/d/u/0/ Crime dataset exists here if you would like to download it and use it for your own project - github.com/coldapache/Baltimore2024JulyCrimeData/blob/main/Baltimore%20Crime%20Data%20July%202024.csv

  • @MicahJohns
    @MicahJohns Місяць тому

    Check out this map/website here - hazards.fema.gov/nri/map (downloadable data)

  • @MicahJohns
    @MicahJohns Місяць тому

    Check out mermaid charts GPT here - chatgpt.com/g/g-1IRFKwq4G-mermaid-chart-diagrams-and-charts

  • @Sam_Grifford
    @Sam_Grifford Місяць тому

    this is the easiest and most informative video I've seen after looking at so many others.... 🗿👍

    • @MicahJohns
      @MicahJohns Місяць тому

      Thanks for stopping by, glad I could help!

  • @RASVIGOR
    @RASVIGOR Місяць тому

    Great but how do you do this on the mobile app

    • @MicahJohns
      @MicahJohns Місяць тому

      I don’t think you can, adobe mobile apps are pretty limited

  • @simonbaillieu7976
    @simonbaillieu7976 Місяць тому

    wow , that was such a good summary and your delivery was spot on thanks i will be watching more of your work

    • @MicahJohns
      @MicahJohns Місяць тому

      awesome thanks for that! happy I could help

  • @tommyrocket2604
    @tommyrocket2604 Місяць тому

    Amazing place, but I have to ask what happened to the GRASS... can't see any grass anywhere!

  • @sreenjoychakraborty5921
    @sreenjoychakraborty5921 Місяць тому

    You saved me man 😁😁

  • @guangxiaosheng4249
    @guangxiaosheng4249 Місяць тому

    你好,我是盛光晓,毕业于武汉大学测绘工程专业,院士课题组成员,前百度地图高级工程师。 我在测绘地理信息科学行业有13年的经验,我熟悉arcgis和qgis的使用,我精通Python数据分析和可视化,我对arcpy、GDAL、Geopandas、folium、rasterio、fiona、pyproj、shapely这些库都非常熟悉,可以处理矢量和栅格数据。我擅长编写arcpy脚本,定制arctoolbox工具箱。 如有机会合作,不胜荣幸:) 如有打扰,请见谅:) 祝你生活愉快,天天开心

  • @MicahJohns
    @MicahJohns Місяць тому

    Google Colab code here - colab.research.google.com/drive/1kZ3GzLVOZU0eU_nK9v4De0ausnlKjHpy?usp=sharing

  • @MicahJohns
    @MicahJohns Місяць тому

    Code here from the video - github.com/coldapache/ArcGIS_JS_SDK_DarkTheme_Editor_Widget/blob/main/Main_Code_WithComments Send random amounts to my cashapp (if you're awesome) - cash.app/$micahjca Documentation/Sandbox - developers.arcgis.com/javascript/latest/sample-code/widgets-editor-basic/

  • @MicahJohns
    @MicahJohns Місяць тому

    Send random amounts to my cashapp (if you're awesome) - cash.app/$micahjca Texas DOT data catalog - gis-txdot.opendata.arcgis.com/search?collection=Dataset The data I used - gis-txdot.opendata.arcgis.com/datasets/cbf41b1fcd724b2fb06e75cd05ad11c7_0/explore?location=32.045253%2C-98.550470%2C6.68 The code - import folium import geopandas as gpd # Load the GeoJSON file geojson_path = '/content/TxDOT_STRAHNET_4976892584963835687.geojson' gdf = gpd.read_file(geojson_path) # Create a map centered around Texas m = folium.Map(location=[31.9686, -99.9018], zoom_start=6) # Add the GeoJSON layer to the map folium.GeoJson(gdf).add_to(m) # Display the map m

  • @othmanabaakil4881
    @othmanabaakil4881 Місяць тому

    Spent 1day looking for the solution, got it in 2:34 min, Thanks <3

    • @MicahJohns
      @MicahJohns Місяць тому

      @@othmanabaakil4881 I’m glad it was helpful!

  • @MicahJohns
    @MicahJohns Місяць тому

    Here's the treemap visual - informationisbeautiful.net/visualizations/trillions-what-is-a-trillion-dollars/ Here's the data via google sheets - docs.google.com/spreadsheets/d/1_YoXOf1-5b30Rt0AOxO9O4XNd-JpBQWovM3z2W9QUuI/edit?gid=1837307547#gid=1837307547

  • @banginzaza
    @banginzaza Місяць тому

    15 year old misdemeanor simple assault. Got E DENIED from both!

    • @MicahJohns
      @MicahJohns Місяць тому

      wow, thanks for sharing. Didn't know they would check that far back

  • @asherbearboy
    @asherbearboy Місяць тому

    I know just a bit about coding but this was interesting

  • @ryanmoore688
    @ryanmoore688 Місяць тому

    i enabled it but it doesn't work still.

    • @MicahJohns
      @MicahJohns Місяць тому

      it may be out of date by now

  • @saki092
    @saki092 Місяць тому

    Thank you so much sir I appreciate

  • @ryancollinsvideo
    @ryancollinsvideo 2 місяці тому

    It was doing it right. Those tattoo designs are traditional

  • @uchihaitachiakatsuki5164
    @uchihaitachiakatsuki5164 2 місяці тому

    🎯 Key points for quick navigation: 00:00 *📝 Introduction to Summarizing UA-cam Videos with ChatGPT* - Brief overview of the method to summarize UA-cam videos using ChatGPT, - Mention of using the paid version of ChatGPT and exploring public GPTs. 00:24 *🔍 Choosing a UA-cam Summarizer GPT* - Searching for UA-cam summarizer options, - Selecting a high-ranked summarizer based on legitimacy and ratings. 00:52 *📋 Obtaining and Summarizing a UA-cam Video* - Instructions to get the link of the UA-cam video to be summarized, - Example of requesting a summary in a "TL;DR" (too long; didn't read) style. 01:36 *🌐 External Site Engagement for Summary* - Explanation of how ChatGPT uses an external site to gather video content, - Summary generation process and modifying the summary direction. 02:17 *✂️ Creating Concise Summaries* - Option to request a very short summary, such as a two-sentence breakdown, - Example of how the summarizer might not always follow instructions perfectly but can still produce concise summaries. 02:57 *💬 Posting Summaries as Comments* - Example of posting the summary as a comment on UA-cam videos, - Encouragement to like the video and check out the channel for more AI-related content. 03:12 *📢 Final Remarks and Channel Promotion* - Mention of other AI-related videos on the channel, - Request for feedback and suggestions in the comments. Made with HARPA AI

  • @wisdomvarsity08
    @wisdomvarsity08 2 місяці тому

    Thanks for creating this video.

    • @MicahJohns
      @MicahJohns Місяць тому

      thanks for stopping by

  • @rehaan1237
    @rehaan1237 2 місяці тому

    damn saved me hours!! really appriciate it man!

  • @camporeviews2613
    @camporeviews2613 2 місяці тому

    thanks

  • @MicahJohns
    @MicahJohns 2 місяці тому

    Get the data here - data-explorer.oecd.org/vis?tm=wages&pg=0&snb=61&vw=tb&df[ds]=dsDisseminateFinalDMZ&df[id]=DSD_EARNINGS%40AV_AN_WAGE&df[ag]=OECD.ELS.SAE&df[vs]=1.0&pd=%2C&dq=......&ly[rw]=REF_AREA%2CPRICE_BASE%2CUNIT_MEASURE&ly[cl]=TIME_PERIOD&to[TIME_PERIOD]=false&lb=bt

  • @asmatu4265
    @asmatu4265 2 місяці тому

    I recently found AI tools like JobSolv that help you create a tailored resume and manage your entire job search. They even send your applications to company websites, making sure each one fits your preferences.

  • @KhuzzPRO-castinater
    @KhuzzPRO-castinater 2 місяці тому

    OKKKKK how the heck ChatGPT would know that when my kid's school timing ends.

    • @MicahJohns
      @MicahJohns 2 місяці тому

      Probably a common time for school release

    • @KhuzzPRO-castinater
      @KhuzzPRO-castinater 2 місяці тому

      @@MicahJohns it's not common like 5 PM 😑😑

  • @mitologia-desvendada
    @mitologia-desvendada 2 місяці тому

    Thanks.

  • @tinac934
    @tinac934 2 місяці тому

    Hi Micah, thanks for the tutorial! Any idea how to construct the prompt to continue using the same character again and again...I am trying to build a story and need the character to stay same...looking forward to hear from you

    • @MicahJohns
      @MicahJohns 2 місяці тому

      You have to utilize the seed feature to do this… little bit advanced. Hoping to release a video soon on the topic.

  • @sawalsh07
    @sawalsh07 2 місяці тому

    Will it produce a UML file? What happens when you press 'Edit with Code'?

    • @MicahJohns
      @MicahJohns 2 місяці тому

      I think it will. Not sure if it still functions like this but I’ll check.

  • @nariatorres9784
    @nariatorres9784 2 місяці тому

    Can you do this in adobe lightroom cc as well?

    • @MicahJohns
      @MicahJohns 2 місяці тому

      You can give it a try but I think the workflow is different.

  • @MartinezRBA
    @MartinezRBA 2 місяці тому

    Beautiful, thanks!!!