Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. D.Analysis

D.Analysis

Scheduled Pinned Locked Moved The Lounge
question
33 Posts 14 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    Nel Omwenga
    wrote on last edited by
    #1

    what are the programming languages best linked with data analysis?

    S 0 T P J 9 Replies Last reply
    0
    • N Nel Omwenga

      what are the programming languages best linked with data analysis?

      S Offline
      S Offline
      Slacker007
      wrote on last edited by
      #2

      Python, I thought - currently that is. Welcome to Python.org[^] There are thousands of videos on YouTube using Python for data analysis, etc. You can work with the Python extension with this: Visual Studio Code - Code Editing. Redefined[^], if you want. I am sure there are other Python code editors out there. Python - Visual Studio Marketplace[^]

      H 1 Reply Last reply
      0
      • S Slacker007

        Python, I thought - currently that is. Welcome to Python.org[^] There are thousands of videos on YouTube using Python for data analysis, etc. You can work with the Python extension with this: Visual Studio Code - Code Editing. Redefined[^], if you want. I am sure there are other Python code editors out there. Python - Visual Studio Marketplace[^]

        H Offline
        H Offline
        honey the codewitch
        wrote on last edited by
        #3

        I don't care for Python, but I have to admit you're right about it - it's what's for dinner when it comes to data analysis. So eat your vegetables. :laugh:

        Check out my IoT graphics library here: https://honeythecodewitch.com/gfx

        P 1 Reply Last reply
        0
        • N Nel Omwenga

          what are the programming languages best linked with data analysis?

          0 Offline
          0 Offline
          0x01AA
          wrote on last edited by
          #4

          Although I hate python because of it's lazy syntax (white space as part of language), I love it because of lybraries like numpy which allows you easily apply 'array'- operations over matrices and vectors

          J 1 Reply Last reply
          0
          • N Nel Omwenga

            what are the programming languages best linked with data analysis?

            T Offline
            T Offline
            trønderen
            wrote on last edited by
            #5

            I always wish that questions like this was expanded with something like "and which specific qualities of the language makes it particularly well suited for my problem area?" Or, turned around: "Which specific language qualities are essential to solve problems in [data analysis], and which languages offer these qualities?" Even if the question is not phrased that way, I always wish that those who provide answers would pretend that it was, and answer accordingly.

            S G 2 Replies Last reply
            0
            • T trønderen

              I always wish that questions like this was expanded with something like "and which specific qualities of the language makes it particularly well suited for my problem area?" Or, turned around: "Which specific language qualities are essential to solve problems in [data analysis], and which languages offer these qualities?" Even if the question is not phrased that way, I always wish that those who provide answers would pretend that it was, and answer accordingly.

              S Offline
              S Offline
              Slacker007
              wrote on last edited by
              #6

              trønderen wrote:

              I always wish that those who provide answers would pretend that it was, and answer accordingly.

              I don't code in Python, never touched it once. I don't need to code in Python or have any understanding of Python, or explain "why", to know that it is the top programming language currently in the market, for data analysis. I answered his question effectively and honestly. The OP should be able to do their own research as to what makes Python ideal for data analysis. If not, they probably should not be programming anything in the first place.

              1 Reply Last reply
              0
              • N Nel Omwenga

                what are the programming languages best linked with data analysis?

                P Offline
                P Offline
                PIEBALDconsult
                wrote on last edited by
                #7

                (Sounds like a leading question to me.) Don't get me started... I thought R was the language of choice for that. But really, I don't think any particular language should be. I use C# to do that. Any off-the-shelf analysis platform can do only so much and get you so far. Then you will always need to go deeper depending on what you find on the surface. For that, you'll need a proper general-purpose programming language; not a scripting language (Python, ptui) and not some analysis-specific platform.

                S J 2 Replies Last reply
                0
                • P PIEBALDconsult

                  (Sounds like a leading question to me.) Don't get me started... I thought R was the language of choice for that. But really, I don't think any particular language should be. I use C# to do that. Any off-the-shelf analysis platform can do only so much and get you so far. Then you will always need to go deeper depending on what you find on the surface. For that, you'll need a proper general-purpose programming language; not a scripting language (Python, ptui) and not some analysis-specific platform.

                  S Offline
                  S Offline
                  Slacker007
                  wrote on last edited by
                  #8

                  https://www.datacamp.com/blog/top-programming-languages-for-data-scientists-in-2022[^] Python is first, R second, according to this site. Python, due to its increased versatility over other languages. I don't see C# anywhere. I love C# and primarily use it for most of my work, but just because I love a specific tool, does not mean it is the tool for everything (i.e. hammer, saw, screwdriver, etc.). I'm not a data scientist or analyst, so I Google these things, because I have no clue.

                  J 1 Reply Last reply
                  0
                  • N Nel Omwenga

                    what are the programming languages best linked with data analysis?

                    J Offline
                    J Offline
                    Jeremy Falcon
                    wrote on last edited by
                    #9

                    I'm not a fan of Python, but when it comes to big data it's extremely popular. So, you'll find a lot of tools, online docs, etc. to work with.

                    Jeremy Falcon

                    P 1 Reply Last reply
                    0
                    • T trønderen

                      I always wish that questions like this was expanded with something like "and which specific qualities of the language makes it particularly well suited for my problem area?" Or, turned around: "Which specific language qualities are essential to solve problems in [data analysis], and which languages offer these qualities?" Even if the question is not phrased that way, I always wish that those who provide answers would pretend that it was, and answer accordingly.

                      G Offline
                      G Offline
                      Gary Stachelski 2021
                      wrote on last edited by
                      #10

                      Here you go. a link to an article that compare "R" and Python as data analysis languages. Python Vs R: Know The Difference - InterviewBit[^]

                      1 Reply Last reply
                      0
                      • P PIEBALDconsult

                        (Sounds like a leading question to me.) Don't get me started... I thought R was the language of choice for that. But really, I don't think any particular language should be. I use C# to do that. Any off-the-shelf analysis platform can do only so much and get you so far. Then you will always need to go deeper depending on what you find on the surface. For that, you'll need a proper general-purpose programming language; not a scripting language (Python, ptui) and not some analysis-specific platform.

                        J Offline
                        J Offline
                        Jeremy Falcon
                        wrote on last edited by
                        #11

                        PIEBALDconsult wrote:

                        I use C# to do that.

                        As those who know, know... Q: What's the best language to do XYZ in? A: The language you're most of an expert in. So, totally agree. That's the only reason I still haven't learned Rust yet. Even though some people go on about regarding Rust being safer, etc. are problems I've already solved in C even over the decades. Still tempting to learn Rust, and if I didn't know another lower level language I most likely would. I just don't have the need to. Rust is like C/C++ and JavaScript had a baby... which should be cool. Just don't have a need to learn it. However, to the original point, Python is so dang popular with big data, he'll be sure to find plenty of libraries to help along the way. So, can also see the appeal if you don't have years of code laying around from your hardcore days for that one shiny moment in time to be used again. :laugh:

                        Jeremy Falcon

                        P 1 Reply Last reply
                        0
                        • S Slacker007

                          https://www.datacamp.com/blog/top-programming-languages-for-data-scientists-in-2022[^] Python is first, R second, according to this site. Python, due to its increased versatility over other languages. I don't see C# anywhere. I love C# and primarily use it for most of my work, but just because I love a specific tool, does not mean it is the tool for everything (i.e. hammer, saw, screwdriver, etc.). I'm not a data scientist or analyst, so I Google these things, because I have no clue.

                          J Offline
                          J Offline
                          Jeremy Falcon
                          wrote on last edited by
                          #12

                          Slacker007 wrote:

                          I don't see C# anywhere.

                          I'm rather disappointed FORTRAN isn't on that list.

                          Jeremy Falcon

                          P 1 Reply Last reply
                          0
                          • H honey the codewitch

                            I don't care for Python, but I have to admit you're right about it - it's what's for dinner when it comes to data analysis. So eat your vegetables. :laugh:

                            Check out my IoT graphics library here: https://honeythecodewitch.com/gfx

                            P Offline
                            P Offline
                            PIEBALDconsult
                            wrote on last edited by
                            #13

                            Can it detect when a text value is parseable as a .net DateTime or SID? Or as an SQL datatype? And compare them as such?

                            H T 2 Replies Last reply
                            0
                            • P PIEBALDconsult

                              Can it detect when a text value is parseable as a .net DateTime or SID? Or as an SQL datatype? And compare them as such?

                              H Offline
                              H Offline
                              honey the codewitch
                              wrote on last edited by
                              #14

                              Probably. I don't know. I don't use Python

                              Check out my IoT graphics library here: https://honeythecodewitch.com/gfx

                              P 1 Reply Last reply
                              0
                              • J Jeremy Falcon

                                PIEBALDconsult wrote:

                                I use C# to do that.

                                As those who know, know... Q: What's the best language to do XYZ in? A: The language you're most of an expert in. So, totally agree. That's the only reason I still haven't learned Rust yet. Even though some people go on about regarding Rust being safer, etc. are problems I've already solved in C even over the decades. Still tempting to learn Rust, and if I didn't know another lower level language I most likely would. I just don't have the need to. Rust is like C/C++ and JavaScript had a baby... which should be cool. Just don't have a need to learn it. However, to the original point, Python is so dang popular with big data, he'll be sure to find plenty of libraries to help along the way. So, can also see the appeal if you don't have years of code laying around from your hardcore days for that one shiny moment in time to be used again. :laugh:

                                Jeremy Falcon

                                P Offline
                                P Offline
                                PIEBALDconsult
                                wrote on last edited by
                                #15

                                Jeremy Falcon wrote:

                                if you don't have years of code

                                Or coding experience. All of these off-the-shelf systems (data analysis or ETL in particular) are there to help beginners make a start, but they can be a detriment if the user never learns to do it from scratch. A custom system may take longer to get going, but it can (ideally) do exactly what is needed.

                                J 1 Reply Last reply
                                0
                                • P PIEBALDconsult

                                  Jeremy Falcon wrote:

                                  if you don't have years of code

                                  Or coding experience. All of these off-the-shelf systems (data analysis or ETL in particular) are there to help beginners make a start, but they can be a detriment if the user never learns to do it from scratch. A custom system may take longer to get going, but it can (ideally) do exactly what is needed.

                                  J Offline
                                  J Offline
                                  Jeremy Falcon
                                  wrote on last edited by
                                  #16

                                  PIEBALDconsult wrote:

                                  A custom system may take longer to get going, but it can (ideally) do exactly what is needed.

                                  Kinda like a custom-built PC. :-D

                                  Jeremy Falcon

                                  1 Reply Last reply
                                  0
                                  • H honey the codewitch

                                    Probably. I don't know. I don't use Python

                                    Check out my IoT graphics library here: https://honeythecodewitch.com/gfx

                                    P Offline
                                    P Offline
                                    PIEBALDconsult
                                    wrote on last edited by
                                    #17

                                    Nor do I.

                                    1 Reply Last reply
                                    0
                                    • N Nel Omwenga

                                      what are the programming languages best linked with data analysis?

                                      T Offline
                                      T Offline
                                      trønderen
                                      wrote on last edited by
                                      #18

                                      Answers to questions like this usually have two major elements (or maybe only one of them): First: "It is the language everyone is using!" Ten to twenty years ago, the obvious answer would be C/C++, regardless of problem area. Thirty to forty years ago, if you asked about "data analysis", maybe Cobol would be what everyone was using. (For numerical problems, Fortran was The Answer.) Today, it is next to completely impossible to make Python programmers identify any application area where Python is not the best. Second: "The function and class libraries for the language are excellent!" This may be a more valid argument than "Everyone uses it". To some degree, it can put your fortune into the hands of library writers of various qualities. Note that some languages require libraries written specifically for that language (and conversely: the library cannot be used with any other language), while other libraries are written to language independent interface conventions and may be available from a multitude of programming languages. (The latter was the norm 20-30 years ago; it has been on the decline since.) Neither argument group says anything about the language as such. Both refer to the 'ecosystem', rather than language. Often, the ecosystem is the more essential. You take it, regardless of the quality of the language that goes with it.

                                      1 Reply Last reply
                                      0
                                      • P PIEBALDconsult

                                        Can it detect when a text value is parseable as a .net DateTime or SID? Or as an SQL datatype? And compare them as such?

                                        T Offline
                                        T Offline
                                        trønderen
                                        wrote on last edited by
                                        #19

                                        You can probably find a library that does that for you. (The Python version of "There is an app for that". The answer is the same, regardless of question.)

                                        P 1 Reply Last reply
                                        0
                                        • N Nel Omwenga

                                          what are the programming languages best linked with data analysis?

                                          L Offline
                                          L Offline
                                          Lost User
                                          wrote on last edited by
                                          #20

                                          Depends on the "data" and the objective. I would argue that Excel and MS Access are adequate for a lot of situations. "Analysis" could mean simply coming up with some totals (i.e SQL).

                                          "Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

                                          P J 2 Replies Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups