Forum Discussion

helalm's avatar
helalm
Helper II
7 years ago
Solved

How to get descriptive statistics for multiple columns

I am working on a data set with couple thousands of rows but with more than 300 columns/variable. Most of the variables are categorical and there some continuous. I need to get descriptive statistics...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    helalm  changed type usually relates to it changing your data types, id have to see your code

     

    in power query maybe just remove that step called changed type?

  • helalm's avatar
    helalm
    7 years ago

    I got it...works great. 

     

    Thank you.

  • vanessafvg's avatar
    vanessafvg
    7 years ago

    helalm  great remember to accept solution so others know what the solution was thanks :)

helalm's avatar
helalm
Helper II
7 years ago

Here is trhe code:

let
Source = Sql.Databases("99999999999"),
CENCDBST01DEV = Source{[Name="CENCDBST01DEV"]}[Data],
dbo_CENST01_V1 = CENCDBST01DEV{[Schema="dbo",Item="CENST01_01_V1"]}[Data],


#"TableProfiling" = Table.Profile( #"Changed Type" as table) as table

in

#"TableProfiling"

helalm's avatar
helalm
Helper II
7 years ago

I got it...works great. 

 

Thank you.

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    7 years ago

    helalm  great remember to accept solution so others know what the solution was thanks :)

    • helalm's avatar
      helalm
      Helper II
      5 years ago

      Hi there,

      I have used Table.Profile function for most part. Now, the requirement somewhat changed and I need to get more stats on multiple variables.
      For example, on continous variables suach age, total scores, etc I need to get N, Mean, Median, STDV, Min, Max, and IQR (Interquartile range),
      and Box plot graph by let's say sites or clinics (See attached BoxPlot picture and formatting). For categorical, N, column % by let's say sites or clinics ((See attached Category example picture and formatting).
      I can create these measures easily and format the report accordingly. However, I Have 80 differrent data sets with more than 1500 variables. Therefore, creatign these measures for 1500 variables would take forever and Table.Profile wouldn't give me all of the stats + Box Plot that I need. Any suggestions?