How to Find Average of DataTable's Column

Help Studio
,
1

Hi everyone,

I am trying to get a data from a car selling website and average of first 100 ads’ car’s KM and price. Like in the below:

sahibinden
sahibinden932×584 126 KB

After finding average of 100 ads’ price and KM, I want to write it an excel cell which belongs to specific car brand.

How can I write an average of these ads to write cell activity ? Could you help me ?

2

Hi @ozgesdvc

Welcome to forum

Can u show the excel file where u need to write the avg?

3

Thank you Nived. This is the excel file ss:

excel
excel712×255 3.05 KB

4

Also this is the my uipath sequence:

uipath
uipath830×514 34.3 KB

5

Hi @ozgesdvc

For calculating the average u can use the below linq query

ExtractDataTable.AsEnumerable(). Average(Function(row) Cint(row (“columnname”)))

2 Likes
6

Dear Nived,
Thank you for your help. It is working for KM because it’s all number. But it is not working in price because it contains “TL”.
It gives this error:
Write Cell: Conversion from string “200.000 TL” to type ‘Integer’ is not valid.

How can I fix this? Thank you.

7

Hi @ozgesdvc

Try this

ExtractDataTable.AsEnumerable(). Select (Function (row) row(“ColumnName”).ToString.Replace(“TL”,“”)).CopyToDatatable.AsEnumerable().Average(Function (row) CDbl(row(“ColumnName”)))

8

It gives:
‘CopytoDatatable’ is not a member of ‘System.Data.EnumerableRowCollection(of String)’ error.