SyntaxByte
SyntaxByte
  • 95
  • 2 646 308

Video

Connect to SQLite Database and Import Data in Excel with No VBA
zhlédnutí 864Před 4 měsíci
In this tutorial, I show you how to use the SQLite ODBC driver to connect to the database from Excel and import data without using any VBA. You can download the ODBC driver I used here: www.ch-werner.de/sqliteodbc/
Import an XML File in Microsoft Excel
zhlédnutí 394Před 7 měsíci
In this video we use Power Query (sometimes known as Get & Transform) to import an XML file into Microsoft Excel. This supports nested XML files, and the query can even be reused with another XML file as long as it has the same structure and element names.
Convert an XML File to CSV with Python - Supports Nested XML
zhlédnutí 2,3KPřed 7 měsíci
In this video, I show you how to use Python and pandas to convert an XML file to CSV. Nested XML is also supported by using a stylesheet to adjust the file to a two-dimensional structure. Source code: syntaxbytetutorials.com/import-xml-into-pandas-and-convert-to-csv/ Helpful links: XPath: www.w3schools.com/xml/xpath_syntax.asp XSLT: www.w3schools.com/xml/xsl_intro.asp
Keep Leading Zeros When Opening CSV or Pasting Text Microsoft Excel 365
zhlédnutí 330Před 7 měsíci
In this video, I show you how to configure Microsoft Excel 365 to retain leading zeros when opening a CSV file or when pasting text from elsewhere.
Blender Python Scripting: Add and Apply a Modifier
zhlédnutí 657Před 9 měsíci
In this video, I show you how to use Python scripting in Blender to automate the application of modifiers. This same code can be used to create a macro to add any type of modifier, such as a mirror, boolean or array modifier.
Get Chat GPT Results in Excel with PowerQuery and OpenAI API
zhlédnutí 972Před 10 měsíci
Learn how to use ChatGPT from Excel with PowerQuery! In this video, we create a function query that can be used to get ChatGPT's response to any question. This is good for asking ChatGPT questions in bulk, or parsing the response in Excel. You will need an OpenAI API Key: openai.com/blog/openai-api
Detect Text Language in Python
zhlédnutí 1,2KPřed 11 měsíci
In this video, I show you how to use the langdetect library to detect the language of text in Python. This is a useful data cleaning step for working with text data which may contain languages other than the desired language. I used it recently for cleaning a set of tweets and removing responses in a language other than English. Langdetect library: pypi.org/project/langdetect/
How to Combine Duplicate or Similar Rows in a Python Pandas DataFrame
zhlédnutí 1,3KPřed rokem
In this video, I cover some strategies for aggregating and merging rows that are similar or near-duplicates in a Python pandas dataframe into a single row. This is helpful for situations where the information could easily be captured in a single row and you want to preserve the information but decrease the amount of rows. I used this recently when working with a set of Twitter data from Kaggle....
Canadian Postal Code Data Validation and Cleanup in Excel
zhlédnutí 1,3KPřed rokem
In this video, I show you how to use Excel to clean and validate a list of Canadian postal codes. The formulas shown will format the postal code, including adding a space and adjusting capitalization where necessary, and then validate it. Canadian postal codes follow the format LNL NLN where L is a letter and N is a number. Written tutorial and formulas to copy: syntaxbytetutorials.com/validate...
Create Interactive Maps in Your Jupyter Notebooks with Folium
zhlédnutí 2,5KPřed rokem
In this video, we cover various features of Folium including ones I have used in my previous videos on OpenRouteService and show you how to create visualizations and interactive maps using folium. The features covered include markers, polylines, geojson overlays, choropleth maps and layers. Key links and references Folium Github: github.com/python-visualization/folium Phoenix City Boundary: map...
Vehicle Route Optimization in Python with OpenRouteService
zhlédnutí 12KPřed rokem
OpenRouteService has a feature-rich Vehicle Route Optimization API based off VROOM, and in this video I show you how to take advantage of this to do vehicle route optimization in Python with openrouteservice-py. VROOM API Documentation: github.com/VROOM-Project/vroom/blob/master/docs/API.md Written tutorial and source code: syntaxbytetutorials.com/vehicle-route-optimization-in-python-with-openr...
Using AI to Sync Song Lyrics
zhlédnutí 11KPřed rokem
In this video, we explore using various Python AI models to sync song lyrics. We cover Spleeter by Deezer, Whisper by OpenAI and text similarity techniques, to create a synced lyric file (LRC file) which can be read by a variety of medium programs to display synced lyrics. The end result is sometimes better than what's available on Musixmatch today, which ends up on Spotify. Try it out for your...
Why You Should ALWAYS Play the Lottery in Pay Day
zhlédnutí 171Před rokem
In this video, we discuss why you should always play the lottery in the Pay Day board game. This board game offers up a lottery space that provides a positive expected value to players. I break down the calculations required to determine this in this video, and discuss how to adjust your board game strategy accordingly. This same concept could be applied to other games which have similar lotter...
Getting Directions in Python with OpenRouteService-py
zhlédnutí 10KPřed rokem
In this video, we cover how to use the openrouteservice-py Python library for OpenRouteService to get driving, cycling or walking directions. We also cover how to use folium to visualize the route. Useful additional documentation: Source code: syntaxbytetutorials.com/getting-directions-in-python-with-openrouteservice-py/ Openrouteservice API documentation: openrouteservice.org/dev/#/api-docs/di...
My 30 Day Linux Challenge with Ubuntu 22.04
zhlédnutí 1,9KPřed rokem
My 30 Day Linux Challenge with Ubuntu 22.04
Setup a Self-Hosted OpenRouteService Instance with Docker on Windows, Mac or Linux
zhlédnutí 20KPřed rokem
Setup a Self-Hosted OpenRouteService Instance with Docker on Windows, Mac or Linux
20 Essential VBA Functions Every Programmer Should Know
zhlédnutí 8KPřed rokem
20 Essential VBA Functions Every Programmer Should Know
Enable Word Wrap for Paragraphs In Adobe Photoshop - Make Text Behave Like MS Word
zhlédnutí 10KPřed rokem
Enable Word Wrap for Paragraphs In Adobe Photoshop - Make Text Behave Like MS Word
Excel VBA InputBox Enter Value to Cell
zhlédnutí 16KPřed rokem
Excel VBA InputBox Enter Value to Cell
Use VBA To Run a Powershell Command and Get Return Value
zhlédnutí 9KPřed 2 lety
Use VBA To Run a Powershell Command and Get Return Value
Excel VBA Google Translate Function with Detect Language!
zhlédnutí 6KPřed 2 lety
Excel VBA Google Translate Function with Detect Language!
Excel VBA UserForm Browse for File to Attach
zhlédnutí 12KPřed 2 lety
Excel VBA UserForm Browse for File to Attach
Excel VBA Loop Through Rows in a Table or Range
zhlédnutí 37KPřed 2 lety
Excel VBA Loop Through Rows in a Table or Range
Automate Solver in Excel on Windows or Mac with VBA
zhlédnutí 17KPřed 2 lety
Automate Solver in Excel on Windows or Mac with VBA
Convert JSON to CSV using Node.js and JavaScript
zhlédnutí 11KPřed 2 lety
Convert JSON to CSV using Node.js and JavaScript
OnePlus 5T in 2022 Long-term Review after Four Years of Ownership
zhlédnutí 5KPřed 2 lety
OnePlus 5T in 2022 Long-term Review after Four Years of Ownership
Excel 365 Create and Open an ODC File
zhlédnutí 8KPřed 2 lety
Excel 365 Create and Open an ODC File
Excel Get Postal Code or Zip Code for Address
zhlédnutí 37KPřed 2 lety
Excel Get Postal Code or Zip Code for Address
Three.js: Particles
zhlédnutí 4,3KPřed 2 lety
Three.js: Particles

Komentáře

  • @profeandres9923
    @profeandres9923 Před dnem

    I used to hate it until they hired me as a Java expert. The thing is, I wouldn't use it for my personal projects; I prefer Python, JavaScript, or even C.

  • @alexandrufilipescu1301

    The volumes now in v8.0 look different. What would you suggest me to do? I wanted to add a custom map and I can't.

    • @syntaxbyte
      @syntaxbyte Před 12 dny

      Make sure the configuration points to the location of your pbf file: giscience.github.io/openrouteservice/run-instance/configuration/

  • @chowhaw3267
    @chowhaw3267 Před 14 dny

    Pal the video is good… however there is too many water drinking sound behind 😂😂😂😂

  • @DavidWilliams-wj4sc
    @DavidWilliams-wj4sc Před 21 dnem

    too much drinking, geez. when i do trainings at work i don't sniffle or drink 1000x. And it was giving you 1.7 miles as straight line distance which is totally useless unless you're flying a plane.

  • @themathman893
    @themathman893 Před 21 dnem

    i created the api key and am doing the same thing in the video. copied his text and every thing and i get a #name? error for the result. anyone have any idea why?

  • @Dick_LongJJ
    @Dick_LongJJ Před 25 dny

    Key not found error :(

  • @GerryStilton
    @GerryStilton Před 29 dny

    Thank you for sharing.

  • @Tichtru
    @Tichtru Před měsícem

    i can't find convert to paragraph text in photoshop 2021. Help me solve the problem

  • @user-zr5ke7np8u
    @user-zr5ke7np8u Před měsícem

    Thanks, helped me a lot !

  • @BhuvanaNarayanamurthy-rb3mi

    Thank you so much! You not only explained the solution in a simple manner, you absolutely channeled the frustration I just went through before I came to search for a solution!

  • @captainwheelbarrow649
    @captainwheelbarrow649 Před měsícem

    Great vid, so many guides skip over key steps or take ages to get to the point

  • @AR-oz4uw
    @AR-oz4uw Před měsícem

    THANK YOU <3

  • @DrewTeter
    @DrewTeter Před měsícem

    I'm working on a script that may or may not already have a modifier existing on an object. How do I get the ID or Name of the modifier I just added? If I run "bpy.context.object.modifiers['ARRAY']" I'll get the modifier named "ARRAY" but that may not be the one I want to edit. The new modifier may be called "Array.001" or "Array.002"... etc

  • @Aashiq3
    @Aashiq3 Před měsícem

    Thank you

  • @travelmindanao5755
    @travelmindanao5755 Před měsícem

    haha is this a talk show?

  • @harrymason6654
    @harrymason6654 Před měsícem

    Very good explain bro. How I can click/touch for a point on one 3D model to make an action? I wan't to create my business card with a game console and when I click on on button of the controller put information on the screen, giving different action on each button on the 3D model.

  • @tehseenullah215
    @tehseenullah215 Před měsícem

    hello great video. i want to get user image from Api and display them in game. how can i do that? can someone help me with this?

  • @Anhphan-os3eo
    @Anhphan-os3eo Před měsícem

    Gold!!! Fantastic brotherrrrr

  • @tyridol
    @tyridol Před měsícem

    the "fvck" in 16:00 give me a loud laugh

  • @ameyavarma8568
    @ameyavarma8568 Před měsícem

    Your a life saver! Thanks for doing my job for me:)

  • @josemanuelromeroperez5112

    Hey! I have a question. I want the textures to not follow the camera. i have been trying a lot of things :(

  • @rogerdoger303
    @rogerdoger303 Před měsícem

    Is that coffee you're drinking? 🙂

  • @jeffersonmiranda7452
    @jeffersonmiranda7452 Před 2 měsíci

    Lol thay always happens to the beats

  • @Bad_B0nes
    @Bad_B0nes Před 2 měsíci

    I tried this method but still when I run neofetch it still says that my device is using the i915 driver for the integrated intel gpu instead of my amd gpu. Any way to fix this? Thx.

  • @RehanBashir76
    @RehanBashir76 Před 2 měsíci

    Very helpful. Thanks

  • @benterrell9139
    @benterrell9139 Před 2 měsíci

    just what i needed to find out, thanks!

  • @tranxuanhung7315
    @tranxuanhung7315 Před 2 měsíci

    Luv uuuuu

  • @antyroux1090
    @antyroux1090 Před 2 měsíci

    Hi there, I am following your steps and it does not work. It simply sees the name, surname, contact, email just as one header then imports all the data under the name in contacts, and then another row named "Field 2 and Field 3 ". Not sure how to fix it please can you give me tip on what I should do to fix this thanks.

    • @syntaxbyte
      @syntaxbyte Před 2 měsíci

      If you fields don't show up on the left hand side when you go to map, something is probably wrong with the way your CSV is setup. I would try opening the file in excel and making sure everything is setup correctly and saving it again. If you do see all those fields on the left hand side, it sounds like something went wrong with the mapping. In that case, map sure you click "Clear map" before you map the fields to make sure any default mappings are removed.

  • @arjunchopra0
    @arjunchopra0 Před 2 měsíci

    Hey Ryan, Great Videos, stumbled upon your channel today while i was working on Open Route Service. I would love to connect with you. Do you have a linkedin? or any other platform you prefer?

  • @kats7945
    @kats7945 Před 2 měsíci

    This was SO helpful! How would you modify the code to display only the shortest travel distance? I also need to figure out a way to display the associated map for each record. Appreciate the guidance.

  • @kll715
    @kll715 Před 2 měsíci

    Hi everyone, I am new to this but I keep getting compile error syntax error anybody know how to fix this?

    • @syntaxbyte
      @syntaxbyte Před 2 měsíci

      A syntax error means something you typed is not valid code. Without more information, there's no more help myself or anyone else can provide.

  • @kabetuong4635
    @kabetuong4635 Před 2 měsíci

    Thank u, this so simple!

  • @Androo53095
    @Androo53095 Před 2 měsíci

    This tutorial was very helpful. I had a 1000+ addresses I had to evaluate for a school project, and as much of a learning curve as this was, it was still infinitely easier than trying to do it manually. As others have suggested, changing Dim Seconds and Dim meters from "Integer" to "Long" solved the problem of longer distances not calculating. Thank you so much for the guide!

  • @shraddhayadav869
    @shraddhayadav869 Před 2 měsíci

    impressive!

  • @mattkolberg2409
    @mattkolberg2409 Před 3 měsíci

    This is really good. Just some constructive criticism. Speaking live, or narrating in a video, you want to avoid doing things that distract the listener. For you, it's taking a sip of whatever it is you're drinking. It happens very often. You'll be a better speaker if you avoid that.

  • @mohamad.Khaled
    @mohamad.Khaled Před 3 měsíci

    thx

  • @UlyssesHaq
    @UlyssesHaq Před 3 měsíci

    Lifesaver! This is exactly what i needed, no need for Python, just pure Excel & PowerQuery. Love it.

  • @alienespinel
    @alienespinel Před 3 měsíci

    i am running openrouteservice in localhost but when i do "route = client.directions(coordinates=coords, profile='driving-car',format='geojson')" i get this error: InvalidSchema: No connection adapters were found for 'localhost:8080/ors/v2/directions/driving-car/geojson?' am i supposed to change something in my docker instance? when i run in my browser localhost:8080/ors/v2/directions/driving-car?start=-75.622187,6.154982&end=-75.558010,6.305241 it works fine. notice that i doesnt have any /geojson in the path request nor json or gpx. plz help :)

  • @daniellerenhertzlieb6679
    @daniellerenhertzlieb6679 Před 3 měsíci

    Thank you so much! This was very helpful.

  • @yoyogamesthebestgames7197
    @yoyogamesthebestgames7197 Před 3 měsíci

    Do my pc has always to be connected to the internet so I can use openrouteservice on my app?

  • @monsieur2D
    @monsieur2D Před 3 měsíci

    this video doesn't show how to use this tool. Care to explain?

  • @shalom6719
    @shalom6719 Před 3 měsíci

    Спасибо очень сильно помог)

  • @GoetheHausMeknes1
    @GoetheHausMeknes1 Před 3 měsíci

    Hi, your video was very helpful to me. Now they have new version 8.1 while the folder data does not exist can you do a video to teach how to import pfb file please?

  • @lemr1972
    @lemr1972 Před 3 měsíci

    I got this message error: run-time erorr '429' ActiveX component can't create object.

  • @cwenfernandes6072
    @cwenfernandes6072 Před 3 měsíci

    Really life saver !!!! Superb have been struggling for days now and have finally figured how to connect. Thank you so much...

  • @yofayo3239
    @yofayo3239 Před 3 měsíci

    THANK YOU VERY MUCH!!! !

  • @romiwahyudi5699
    @romiwahyudi5699 Před 3 měsíci

    thanks a lot

  • @Revolg88
    @Revolg88 Před 4 měsíci

    Yo. this video is awesome. BTC at 9K? lol. Hope everyone held. Anyone know to do this with UCID on coinmarketcap instead of symbol? For example want to add Zyncoin but Zyn comes up as zynecoin, which is incorrect

  • @r2igames
    @r2igames Před 4 měsíci

    THANK YOU

  • @HarvestHarmonics
    @HarvestHarmonics Před 4 měsíci

    How can I take the input value from the inputbox function and add it to a string in a specific cell location? In other words, if I have a unit of measure as part of a text string in cell E4, how do I specify that the string the user enters should be placed in the string in that cell?