Dirty, unfriendly and expensive - but still the best city in the world

London may have put on a cheerful face during the Olympics but tourists have still rated the city poorly in terms of friendliness, cleanliness and value for money, a survey has shown.

Of 40 cities worldwide, London this year ranked second to last for the friendliness of its locals, according to a poll by travel website TripAdvisor.

Only Moscow fared worse, while Mexico's Cancun ranked first.

Britain's capital barely performed better in the nine other categories of the poll, ranking 28th for safety, 26th for cleanliness and 35th for best value for money.

On the upside, London was rated fourth best city for shopping - behind New York City, Bangkok and Dubai - and fifth for the quality of taxi services.

The study was based on responses from 75,000 TripAdvisor users surveyed last month.

"While London hasn't ranked particularly highly by those that have reviewed the city this year, it's important to remember that many of the respondents may have experienced London before major changes were made or post the events of the summer," said Emma Shaw, a spokeswoman for TripAdvisor.

London was still voted the best city in the world in TripAdvisor's 2012 Travellers Choice Awards, Shaw noted.

"This study perhaps proves that even a great city isn't going to be perfect in every way," she said.

World city survey results

(First, second and third placings)

Friendliest locals     Cancun, Tokyo, Lisbon

Friendliest taxi drivers     Tokyo, Cancun, Singapore

Best taxi services     Tokyo, Singapore, Dubai

Cleanest streets     Tokyo, Singapore, Zurich

Ease of getting around     Zurich, Vienna, Singapore

Best public transport     Tokyo, Zurich, Munich

Best value for money     Lisbon, Budapest, Bangkok

Best for shopping     New York City, Bangkok, Dubai

Safest city     Tokyo, Singapore, Dubrovnik

Low rankers

Friendliest locals     Moscow, London, Hong Kong

Friendliest taxi drivers     Moscow, Beijing, Brussels

Best taxi services     Moscow, Beijing, Kuala Lumpur

Cleanest streets     Mumbai, Marrakech, Punta Cana

Ease of getting around     Mumbai, Punta Cana, Moscow

Best public transport     Hanoi, Sharm el Sheikh, Marrakech

Best value for money     Oslo, Moscow, Zurich

Best for shopping     Moscow, Oslo, Punta Cana

Do you agree with the survey results? Post a comment below and share your thoughts.